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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using a Form to set a specific date in multiple queries Access 97
I attemped this as suggested and it also did not return any rows. However I did notice that it returns only the 7:00:00 AM portion. Is there a function that returns the entire General Date? Like in the format above. 2/4/01 7:00:00 AM? thanks- cbenn
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using a Form to set a specific date in multiple queries Access 97
I am having a problem with Microsoft Access 97. I want to set up a form which passes the date and time to multiple queries. for instance, The below is my where statement. Where [Table][Time] Between Forms!Time!BegTime and Forms!Time!EndTime Now I am aware of how to set the sql statement up...- cbenn
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
