Date & Time problem

[rbutler6]

I need to create a quiery that will pull the information from the patient table to show me all the appointments for that day. i need to put this information in a report that has to be pulled up everyday and show that days appointments. is there any way to do this.

rbutler6

 

[raskew]

Hi -

Without knowing your table structure, it's difficult to provide a precise fix. However, what you'll probably need to do:

1) Create a new query and pull in the fields from your table that you want to be returned.

2) In the appointment date/time field's criteria place: = date()

3) In the sortby box, Ascending

4) Run the query and when you are satisfied with the results, use the Report Wizard to create a report based on your query.

HTH - Bob

 

[rbutler6]

Hi -

Without knowing your table structure, it's difficult to provide a precise fix. However, what you'll probably need to do:

1) Create a new query and pull in the fields from your table that you want to be returned.

2) In the appointment date/time field's criteria place: = date()

3) In the sortby box, Ascending

4) Run the query and when you are satisfied with the results, use the Report Wizard to create a report based on your query.

HTH - Bob

Thank you, this seemed to have worked, I tried this early but I think I was putting the =date() in the wrong place. Well I might be back for more help. Thank you very much.

Rose

 

[raskew]

Hi Rose -

Glad it worked for you.

Best Wishes - Bob