help plz...

[dgoulston]

how do i get a query to ask for an input of the date as its in long format and i only want the user to enter 99/99/99
so that wen the query runs it asks for unput of jus date not time too.....

i tried:
[date:]+"*"
but that dont work.. any idea??

thanx

DAL

 

[Twin]

Have you tried to put Format ([your field name], "dd/mm/yy") in your design grid? Then in the criteria you can ask for the prompt [Enter date required] etc..
It works on mine..
HTH
Chris

 

[dgoulston]

thanx

i did it using a form in the end, it is much prettyier than the way i origionlly planned and more user friendly..

thanx

DAL