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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: logicmystic
- Order by date
-
a tough date/time question
What you need is a wild card for the time. The date and time are stored as you've noticed. Depending on your version of Access you can get away with something like this: like [Enter a Date] & "*" as the criteria expression in the query HTH N.- logicmystic
- Post #3
- Forum: Microsoft: Access Forms
-
Yet another date/ time question
If all you want to do is concatentate the fields, for what ever reason, (sometimes you don't want to store the time in the same field as the date for query purposes). If you have an unbound field on the form named dtm your code would be: dtm =[forms]![fdetailbyfacility]![arrivaldate] & "...- logicmystic
- Post #4
- Forum: Microsoft: Access Forms
