Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.33 seconds.
Search: Posts Made By: stopher
Forum: Queries 08-12-2017, 08:26 AM
Replies: 12
Views: 466
Posted By stopher
Re: Calculate average length of buying

Unless I'm misunderstanding the problem, then to calculate the average payment period in months then you just need:

( (Last paymentment month) - (first paymentment) ) / (number of payments)
...
Forum: Sports, Health & Fitness 06-10-2017, 09:38 AM
Replies: 8
Views: 3,695
Posted By stopher
Re: Stopher

Hi Doc. Yes I agree it's a category I wasn't which to put in. Maybe I should have put it in the water cooler lol.

Thanks for everyone's wishes and sorry for not updating. I've been PM'd so I...
Forum: Theory and practice of database design 04-30-2017, 01:57 AM
Replies: 5
Views: 1,594
Posted By stopher
Re: "OOP's Beginner - Intro - Nifty Access"

It's a ludicrusly trivial point i know but I think OOP is generally stands for and is pronounced as "Object Oriented Programming" not "Object Orientated Programming". I guess it stems from the...
Forum: Excel 04-14-2017, 10:50 PM
Replies: 6
Views: 1,087
Posted By stopher
Re: Circular references

Your circular error is in cell K23. The formula in this cell is =23:42191 whatever that is supposed to mean. If you delete this formula then the circular reference disappears.

What were you...
Forum: General 03-25-2017, 10:24 AM
Replies: 7
Views: 586
Posted By stopher
Re: Crosstab with more than one header row

When you look at the link provided by plog, you will see there's an option to link using a connection. I highly recommend you do this. i.e. open a new spreadsheet and create a "connection" to your...
Forum: General 03-25-2017, 10:12 AM
Replies: 7
Views: 586
Posted By stopher
Re: Crosstab with more than one header row

As CJ mentioned, you can only have one column header. But you can quite easily create a new pseudo header by concatenating the two fields you want.

So in your example if you have a field called...
Forum: Sports, Health & Fitness 03-24-2017, 12:49 PM
Replies: 8
Views: 3,695
Posted By stopher
Stopher

Not sure if this is the best section to post this but here we go..

About four years ago my neighbour was diagnosed and subsequently passed away as result of a fairly rare cancer (mesothelioma)....
Forum: Queries 03-02-2017, 06:49 AM
Replies: 2
Views: 254
Posted By stopher
Re: Query with Append of 4th table

Sounds like you what to use UNION so that you stack the results of your query with those of table 4.

Google union.

But it's not normal to union data of different granularity so might be useful...
Forum: Tables 02-16-2017, 11:55 AM
Replies: 21
Views: 1,594
Posted By stopher
Re: Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

I agree, Access is sadly lacking in a datagrid view (akin to Excel view). The datasheet view doesn't even come close. Some applications are well suited to grid style view for user interaction, even...
Forum: Tables 02-16-2017, 11:50 AM
Replies: 21
Views: 1,594
Posted By stopher
Re: Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

The solution I provided implements the required constraint on the table. You only need to run the SQL once because when you run it the constraint will be implemented in the table and will remain...
Forum: Tables 02-14-2017, 09:09 AM
Replies: 21
Views: 1,594
Posted By stopher
Re: Record (A, B) is the same as (B, A): how to prevent this kind of duplicates

An alternative option is you can add a constraint to your table like this:

ALTER TABLE tblWords ADD CONSTRAINT ckWords
CHECK (
NOT EXISTS (
SELECT * FROM tblWords AS t
WHERE...
Forum: Queries 02-07-2017, 05:16 AM
Replies: 33
Views: 1,575
Posted By stopher
Re: Convert string to formula

Why do you say the OP is using Excel thinking. As I see it the OP it describing a real world problem i.e. the calculation of charges are dependent upon a charge type (which presumably can be...
Forum: Tables 01-18-2017, 05:02 AM
Replies: 5
Views: 404
Posted By stopher
Re: Enforce Referential Integrity

Selecting "Enforce Referential Integrity" is enforcing mandatory participation i.e. if I put a vlaue in this table then it MUST exist in the related table.
But you may want optional participation....
Forum: Queries 01-11-2017, 05:44 AM
Replies: 15
Views: 578
Posted By stopher
Re: Running Amt Total Based on 3 Days

Maybe you could post a copy of your table in a new database and post here. The problem with this sort of problem is we can't see where you are starting from so make assumptions.
Forum: Forms 01-10-2017, 12:44 PM
Replies: 5
Views: 402
Posted By stopher
Re: 5 Cascading fields on Form wont narrow selection

I made some changes to the schoolid combo (event) and the sessionid source. See attached
Forum: Queries 01-10-2017, 12:26 PM
Replies: 15
Views: 578
Posted By stopher
Re: Running Amt Total Based on 3 Days

I've added speech marks around [DR $ Amt] and change the square brackets for the table name to speech marks so [Daily Originations] becomes "Daily Originations".

I've also removed another speech...
Forum: Queries 01-10-2017, 11:35 AM
Replies: 15
Views: 578
Posted By stopher
Re: Running Amt Total Based on 3 Days

The speech mark is a very strange character to have in a field name particularly as it didn't appear in the fieldname in your first post.

Yes the speech mark could cause problems because the...
Forum: Queries 01-10-2017, 09:43 AM
Replies: 15
Views: 578
Posted By stopher
Re: Running Amt Total Based on 3 Days

Looks like you've got a speech mark in this:

[Settlm't Date]

Would that be the problem?
Forum: Queries 01-10-2017, 05:38 AM
Replies: 15
Views: 578
Posted By stopher
Re: Running Amt Total Based on 3 Days

This will give you your result list. You can then join with your limit list and apply the limit criteria:

SELECT CustomerID, Amount, SettlmtDt, DSum("[Amount]","tblInvoices","customerID='" &...
Forum: Forms 01-10-2017, 04:52 AM
Replies: 5
Views: 402
Posted By stopher
Re: 5 Cascading fields on Form wont narrow selection

The row source in cboSessionID is refSession. So when you choose Lowell (3) from cboSchoolID the row source selects sessions matching 3 from refSession of which there is only one record - spring.
...
Forum: General 01-07-2017, 01:29 AM
Replies: 6
Views: 546
Posted By stopher
Re: Video Tutorials

They are active but you need to override the security on your browser.

In Chrome for example I see a small shield icon appear in the link bar. I click on it and click "unload safe scripts". Then...
Forum: Queries 01-06-2017, 01:20 PM
Replies: 7
Views: 675
Posted By stopher
Re: Append query with x-y number of records

How many records do you typically want to add? It's actually quite easily to do this using SQL.
Forum: Modules & VBA 01-06-2017, 01:02 AM
Replies: 2
Views: 406
Posted By stopher
Re: VBA Date issue

Use IsNull() in VBA to check for null values.

"Is Null" is really for SQL.


As a tip you might want to consider switching your If statement round to avoid testing for negative:

If...
Forum: Modules & VBA 01-05-2017, 05:52 AM
Replies: 4
Views: 266
Posted By stopher
Re: Month(Date) and Day(Date)

You could use the following:

Format(Date,"yymmdd")
Forum: Macros 01-04-2017, 12:50 AM
Replies: 4
Views: 1,820
Posted By stopher
Re: CurrentDb.Execute for updating record

Here's another link

http://www.w3schools.com/sql/sql_update.asp

You can also use the query builder in Access to create the SQL for you. Then copy the syntax.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:57 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World