Re: Most Current Rev Only

From: "Micky" <birdman80107@xxxxxxxxx>
Date: 19 Jan 2006 09:57:06 -0800

When you create your query change it to a crosstab query and then
change it back to a select query and you will have a new line "Total"
as one of your drop down options for your query. Select Max in the
drop down for your "Date" column. That will give you the Max date
which will be the most current year. I hope this helps.

Micky

.

Prev by Date: Re: Multiple combo boxes - send parameters to a query?
Next by Date: Re: Joining two fields from one table to one field in another table
Previous by thread: Re: getting all entries from main table and matching from another
Next by thread: Re: Most Current Rev Only
Index(es):
- Date
- Thread

Relevant Pages

RE: Access: How to supress those "You are about to update..." warnings
... before running the query, that will turn off this irritating warning ... and after running the query change it back to true ... Prev by Date: ...
(microsoft.public.access.forms)
RE: formatting query row data as columns in report
... Check Help on creating a crosstab query, and then base the report on this query ... Prev by Date: ...
(microsoft.public.access.reports)
Re: First - Last
... If a crosstab query doesn't do what you want, ... http://www.mvps.org/access and search for "concatenate". ... Prev by Date: ...
(microsoft.public.access.queries)
No fields selectable for report
... I am trying to make a report based on a crosstab query. ... Prev by Date: ...
(comp.databases.ms-access)
RE: save crosstab query result
... It worked as you said by creating the crosstab query and then subsequently ... "Ofer" wrote: ... Prev by Date: ...
(microsoft.public.access.queries)