Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jmw713
-
Querying Dates problem
I am having a query problem with dates as well. I am basically new to Programming. I know how to set criteria for a search, but what I want is more difficult at least for me. I have a table that stores Dates I need a query to return, lets say only 4-1-01 through 7-31-01 for the years 2001-2004...- jmw713
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Query the month of January for all years
First off thanks for the reply. My problem is I am very new so alot of this makes no sense yet. Below is the code I have which was input automatically after I enter the criteria. The only problem I have now is I cannot get the query to return records on services that were conducted in January...- jmw713
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Query the month of January for all years
I have a customer table, with install dates and service dates. What I am having trouble with is, I need the query to return the service date or if null return the install date. I can't seem to get them both to work. The other issue is the numeric date for January (01) returns no values and 1...- jmw713
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
