Hi Ben, In the criteria for your query use "Between [Enter Start Date] and [Enter End Date]". This will prompt you for the start and end date for your range.
Glenn P. Jones IHS -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ben Norman Sent: Wednesday, 29 June, 2005 9:33 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: Date Range Query I really do not want to put the dates in manually if i do not have to, I want the query to ask me for the range every time. --- In AccessDevelopers@yahoogroups.com, "Tesiny, Ed" <[EMAIL PROTECTED]> wrote: > I would use: Between #01/01/05# and #06/29/05# substituting whatever > dates you want > > Ed Tesiny > [EMAIL PROTECTED] > > > > -----Original Message----- > > From: AccessDevelopers@yahoogroups.com > > [mailto:[EMAIL PROTECTED] On Behalf Of Ben Norman > > Sent: Wednesday, June 29, 2005 11:38 AM > > To: AccessDevelopers@yahoogroups.com > > Subject: [AccessDevelopers] Date Range Query > > > > I know this is probably a simple thing to do but..... > > > > I have a table I want to pull or look up date ranges, but I > > seem to be > > doing something wrong. > > > > What am I missing if i want to type in a DATE FROM to a DATE TO range > > and populate a query with that info??? > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > Yahoo! Groups Links > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
