REPEATED DATA IN ACCESS WHILE WRITING QUERIES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how to avoid repeated records when executing a query.
Ex: 10 labour are working, daily their name - salary - over time details are
entered. at end of the week, if i want to know what is the max OT for every
labour. I tried but i am getting lot of unwanted records.
please send me reply.
regards
Murali
 
Look at the Access HELP section on "Totals" queries. Create a query, select
"Total" vs. "Select", then group on employee name/id and sum the work hours.
-Ed
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

historic VAT Rate lookup 10
combine two tables in a query 6
Need to get a field to repeat in a table or query 5
Repeat macro until record count of query = 0 0
Access Select, Copy,Paste and Save data from subform in Access 2007. 0
Repeating records in Query 20
Running into error while writing Append Query 2
Access stripping decimal places in query 1

Back
Top