|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 15th, 2006, 05:59 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
query to set criteria of latest date
I have a table with a date column (generally but not always weekly
intervals), and other values. I want to create a query that will return the values for the latest date. 
|
|
#2
February 15th, 2006, 06:31 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
query to set criteria of latest date
Put this in the Criteria row of your date field column. Change the named to
your date field name and your table name. It will return only records that match the most recent date in your table. DMax("[MyDateFieldName]","MyTableName") "r subrahmanian" wrote: I have a table with a date column (generally but not always weekly intervals), and other values. I want to create a query that will return the values for the latest date.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| using a form with combo box to input criteria | Christina | Using Forms | 16 | February 3rd, 2006 08:47 PM |
| Reports with Date Range - Errors | jwr | Setting Up & Running Reports | 12 | August 8th, 2005 12:57 PM |
| Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
| Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
| Date reference as criteria in query | Tim Brown | Running & Setting Up Queries | 1 | June 21st, 2004 01:01 AM |
Linear Mode
