| Date comparison [message #374601] |
Wed, 20 June 2001 15:38 |
Brian Coats
Messages: 2
Registered: June 2001
|
Junior Member |
|
|
I am trying to use an SQl querry in VBA to obtain the max date from a group of records and then use that to open a form with only the record that had the right ID and Date. I have the correct information but when I use the docmd.OpenForm method in Access and try to use date = rec!date in the where condition the date won't match even though it exists. I have also tried date = DateValue(rec!date) this works in the querry engine but I need to be able to pass the Date to the function. What else can I do?? Thank you for you help.
Brian Coats
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
