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

Rabu, 31 Agustus 2011

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

G'day Graham,

Some of this is my ignorance and misuse of terms.

At 1/09/2011 07:23 AM, you wrote:

>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.

I should have said 'when filtered. I have now removed that problem by
using "qYearStartTy" which delivers records for "This Year" without a filter.

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

"qAttThisMonth" includes records for many years. There are no multiple records.

>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.

I will correct that error.

Many thanks,

Regards,

Robin

>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
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>