need help with syntax for a date

[atadbitslow]

Hi,

I have this expression in a query. I can't figure out how to get the date the user will enter to work with the criteria.

DLookUp("res_begin_start","zoom meetings tab","zoom_meeting_date=" & #[Please enter meeting date: mm/dd/yyyy]#)

Thank you!

 

[dhookom]

It might help if you provided the entire SQL view of the query and tell us what happens when you try your expression.

You could try:

DLookUp("res_begin_start","zoom meetings tab","zoom_meeting_date=#" & [Please enter meeting date: mm/dd/yyyy] & "#")

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[atadbitslow]

Thanks very much! That did the trick!

 

[dhookom]

It's recommended to mark correct answers by clicking the "[highlight #729FCF]Great post![/highlight]" link.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016