Forms/Queries

[Guest]

I have developed a absence database at my company where by the absences are
inputted daily into a form. For "fire & safety" reasons we have to print a
copy of the absences, and currently i am doing this by means of a query that
prompts you to enter the date...however, to make this better i would idealy
like to be able to click on a toggle button on the switchboard and the
current days result to come up...does anyone know if this is possible?!!
Thankyou!x

 

[Guest]

You would have to use a query anyway to filter the records.

I think it would just be a case of inserting "=date()" into the criteria for
the date and using a command button to open the query (or a report using the
query as the source).

 

[Guest]

Thank you so much "scubadiver"!!!

You would have to use a query anyway to filter the records.

I think it would just be a case of inserting "=date()" into the criteria for
the date and using a command button to open the query (or a report using the
query as the source).

 

[Guest]

So it worked then? Using "date()" was an educated guess.

 

[Guest]

yes, it did work indeed!!

So it worked then? Using "date()" was an educated guess.