problem with count! another prob!
I have a query which sorts all the "Work Order for today's date"
SELECT WorkOrder.[WorkOrder#], WorkOrder.Craft, WorkOrder.Description, WorkOrder.Zone, WorkOrder.Building, WorkOrder.[Room#], WorkOrder.TypeOfRequest, WorkOrder.Priority
FROM WorkOrder
WHERE (((WorkOrder.DateRecieved)=Date()));
How can I add a count function which will give me the total number of workorders when i run this query.
The work order number is a unique id no. that I enter....so i basically want it to be able to count the workorders for todays date!
For eg...if today work orders start from 102 and end at 128....I want it to tell me that No. of work orders in Todays date are 26.
Do i make sense.............I hope I phrased my problem right!
thankyou
I have a query which sorts all the "Work Order for today's date"
SELECT WorkOrder.[WorkOrder#], WorkOrder.Craft, WorkOrder.Description, WorkOrder.Zone, WorkOrder.Building, WorkOrder.[Room#], WorkOrder.TypeOfRequest, WorkOrder.Priority
FROM WorkOrder
WHERE (((WorkOrder.DateRecieved)=Date()));
How can I add a count function which will give me the total number of workorders when i run this query.
The work order number is a unique id no. that I enter....so i basically want it to be able to count the workorders for todays date!
For eg...if today work orders start from 102 and end at 128....I want it to tell me that No. of work orders in Todays date are 26.
Do i make sense.............I hope I phrased my problem right!
thankyou
Last edited: