G
GretOgrady
Hi - I've got a query that will be run on a weekly basis that will
take newly imported information and append to a table. One of the
fields is an inserted date (which can only be a friday - thus a
specific date). I was just creating in input box "Fiscal Week Ended:
[input date]" however the result isn't outputting as a date and I need
to control the user more and basically only allow them to choose from
predetermined list.
Is this possible to do? I've got a table that contains the dates
they could pick from so I was thinking maybe I need to create a form
but don't see how to integrate the form into the query the user would
execute...
Thanks for any/all help!
Gretchen
take newly imported information and append to a table. One of the
fields is an inserted date (which can only be a friday - thus a
specific date). I was just creating in input box "Fiscal Week Ended:
[input date]" however the result isn't outputting as a date and I need
to control the user more and basically only allow them to choose from
predetermined list.
Is this possible to do? I've got a table that contains the dates
they could pick from so I was thinking maybe I need to create a form
but don't see how to integrate the form into the query the user would
execute...
Thanks for any/all help!
Gretchen