Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access Query & Dates
Name: Ringo Date: March 26, 2004 at 03:18:22 Pacific OS: Win 2002 CPU/Ram: Unknown
Comment:
I am trying to make a query that picks out all the data that falls within different weeks. Is there any way of getting the query to identify which week a date is from. Failing that is it possible to do the same thing but identifying which month a date is from. Im using Access 2002
Name: Jennifer SUMN Date: March 26, 2004 at 15:30:19 Pacific
Reply:
Create a query that requests user input.
For example, in the Criteria box under the "Date" field in your query type [Please enter Starting Date]
In the next box underneath, type [Please enter Ending Date]
When running the query, you will prompted to enter the dates. Make sure you enter the dates in the same format they are entered into the field in your table.
0
Response Number 2
Name: Ringo Date: March 29, 2004 at 02:40:05 Pacific
Reply:
I didnt think of doing it that way, thanks for the tip : )
Summary: I have a field in my DB called "DateOpened". I need to run a query that will scan these dates and return to me, for example, all files opened between 2/1/<any year> and 2/28/<any year>. I tried...
Summary: Wondering if some access guru can help me out. I have a database thats date driven. I want to write a query that will select all date that is older then say june 3rd 2002, move it to a back up databa...
Summary: I have a Qry set up in access that pulls from 2 tables. Table 1 is a site location master list table 2 is a status of data entry. The query pulls site from table 1 (linked to table 2) and the status ...
0 
