I have a simple Access 2000 database with (7) fields, which are Work Order#, Consultant, Item, Activity, Hours Worked & Client.
How do I create a query that will ask me what Work Order# do I wish to search for and after I enter the number, it will display all the records AND the total the number of hours worked.
My goal is to be able to print out the number of hours worked sorted either by item or activity or consultant.
I figured how to have it ask the question (enclose the text in [] but I cannot get it to summarize.
Thanks
