DAngelia wrote: >When I use 'Max' in a query in a date field. I do not get the correct
>records for the fields associated with the date field. I do however get the
>correct 'Max' date.
>Why is this happening?
>Example field names:
>PayeeDate
>Activity
>HoursSpent
>AmountPaid
Hard to tell without seeing the query.
An aggregate function is normally used in a Totals type
(Group By) query. The other fields in the query must be
specified as Group By, which means they will all be the
same. So, how could they be wrong?
Maybe(?) you want to sue a SELECT TOP 1 type query instead
of a Totals query??
Re: Counting only Yes values from a Yes/No field. ... A Totals typequery is not updatable, ... >>>and a subform which records activities to be taken following that appointment.... >> The activities subform can do that in a footer text box ... (microsoft.public.access.formscoding)
Re: Microsoft Cleanliness ... preceeds each table with the word TABLE and each query with "QUERY". ... Make sure the import window can't be resized. ... We have a beautiful marsh, Cootes Paradise, here at the west end of Lake ... Ontario but it's been dying for decades because of the invasion of carp,... (comp.databases.ms-access)
Re: Microsoft Cleanliness ... preceeds each table with the word TABLE and each query with "QUERY". ... We have a beautiful marsh, Cootes Paradise, here at the west end of Lake Ontario but it's been dying for decades because of the invasion of carp, which muddy the water, and uproot the vegetation. ... (comp.databases.ms-access)
Re: Writing Executable VBA Statements ... i'm not sure if the system 'took' my last reply to your posting below marsh,... is the way the SQL query stands at present. ... following message "Syntax error in query expression... > query is the key to the whole operation of duplicating a ... (microsoft.public.access.formscoding)
Re: textbox controsource as recordset field ...Marsh,... Thanks for the suggestion.... The field being returned in this query is a text field. ... >>> the case when it is zero?... (microsoft.public.access.reports)
