sum dates query

[Guest]

Hi.
Need some help with a problem I'm having.
I made a query that would sum the working hours of an employee. I then
implemented another condition that would search for specific dates. The
problem is that when I implemented the second condition the first one stoped
working, i.e. it stoped showing the results sumed up and stared to show them
seperately.
How do I make a query that searches for specific dates and sums up the
employees working hours?
Thanks for the help.

 

[Guest]

Hi Diogo,

Just a guess, since you did not include the SQL statement, but try
unchecking the Show on the field that you are using to search for specific
dates, and change the Group By on this column to Where.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________