ACCESS FEED: RE: [MS_AccessPros] Missing records with 'nil returns'.

Rabu, 31 Agustus 2011

RE: [MS_AccessPros] Missing records with 'nil returns'.

Hi Robin

There are two things that are puzzling me:

In your original post you said: "The query "qYearStart" has 61 entries." If
so, why do you need to filter on qYearStart.YearStart at all? The query
will return all 61 records with or without the filter.

Also, does qAttThisMonth include any records which are NOT for the current
year, and can it have multiple records per ClubID?

Note that there is another unrelated problem with this expression:
[qAttThisMonth!Members]-[qYearStart!Members] AS Change

It should be:
[qAttThisMonth]![Members]-[qYearStart]![Members] AS Change

Or, if you prefer, leave out the square brackets altogether.

Best regards,
Graham

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Thursday, 1 September 2011 00:25
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Missing records with 'nil returns'.
Graham,

That delivers 61 records, 3 without ClubID.

Robin

At 31/08/2011 08:07 PM, you wrote:
>Robin,
>
>As a matter of interest, how many records does this give you?
>
>SELECT * FROM qYearStart WHERE
>(
>qYearStart.YearStart=IIf(Month(Date())>=7,
>DateSerial(Year(Date()),7,1),
>DateSerial(Year(Date())-1,7,1))
>);
>--
>
>Graham