B
Brodie Farrar
OK, So I use a database to track work orders, I want there to be a window on the "Work Order Form" that will display the number of completed work orders for today. How do I go about doing this?????
Brodie said:OK, So I use a database to track work orders, I want there to be a
window on the "Work Order Form" that will display the number of
completed work orders for today. How do I go about doing this?????
OK, So I use a database to track work orders, I want there to be a window on the "Work Order Form" that will display the number of completed work orders for today. How do I go about doing this?????
Brodie said:I did try the query, I just could not figure out how to get the info
i wanted....
OK, So I use a database to track work orders, I want there to be a window on the "Work Order Form" that will display the number of completed work orders for today. How do I go about doing this?????
OK, So I use a database to track work orders, I want there to be a window on the "Work Order Form" that will display the number of completed work orders for today. How do I go about doing this?????
Thank you John, Please let me know what info you need,
I Have the a work orders table, which has a "Time Completed" Field with the date, I want to Count all completed work orders for the Current day, and display that total on the "work order tracking" Form.
The issue i run into is I can't figure out how to turn the Date/time into just date in the query, I am not sure how this process works?
GREAT! That worked, But i forgot one thing
I have "Stop Code" Where I want the count only when "Stop Code" = '00'
So your =DCount("*", "[Work Orders]", "[Time Completed] >= Date()"), But How do I have it just count with stop code 00?
OK, so I tried that code, and I get and error, it just says #error in the text field,
Could this be due to the fact that [Stop Code] is a look up field?
OK, So I use a database to track work orders, I want there to be a window on the "Work Order Form" that will display the number of completed work orders for today. How do I go about doing this?????
Sorry to bother you one more time, But I would like to turn this:
=DCount("*","[Work Order Tracking]","[Time Complete] >= Date() AND [Stop Code] = 1")
into one for THIS MONTH, THIS WEEK, and THIS YEAR
Can you help???
Thank you, and again, sorry for bothering you.
I am still keeping the original, but now thought it would be great to have the others, if you can assist, I have tried, can't seem to get the code quite right.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.