Access query

Good afternoon

I am attempting to construct a query, but have not succeeded in
structuring the expression. Anyone's help will be welcome.

I have multiple entries for each date, called DateEntered, lets say
there are eight seperate enteries for a date. Each entry has to
quantities, an AMTime and a PMTime.

I wish to structure a query which groups all of the data from the same
dates, and adds all of the AMTimes and PMTimes, to give a total of all
times for each date, and returns a unique result for each date.

Thanks, in anticipation,
Philip

"adds all fo the AMTimes and PMTimes" doesn't make any sense without you
providing some sample records and expected result/display in your query.

--
Duane Hookom
MS Access MVP


wrote in message
oups.com...
Good afternoon

I am attempting to construct a query, but have not succeeded in
structuring the expression. Anyone's help will be welcome.

I have multiple entries for each date, called DateEntered, lets say
there are eight seperate enteries for a date. Each entry has to
quantities, an AMTime and a PMTime.

I wish to structure a query which groups all of the data from the same
dates, and adds all of the AMTimes and PMTimes, to give a total of all
times for each date, and returns a unique result for each date.

Thanks, in anticipation,
Philip