Query help - Totals by Delivery Method by Hour

[jdrumgold1983]

Hi,

Hoping someone could help me with a problem that I am having. Fairly new to Access and have been trying to create a query that allows me to see how many trays or product I have confirmed each hour of the day by delivery method. I have a table that looks similar to the one below:

Date	Delivery method	Time confirmed	qty
05/05/14	AM	13:06	4
05/05/14	AM	14:08	6
05/05/14	CC	16:09	10
05/05/14	CC	18:10	11
05/05/14	YC	18:15	2

I am looking for a query to show me the total number of trays confirmed for delivery methods ending in C, ie the totals of YC and CC together per hour.

Could anyone provide any help or point me in the direction of where I should be going with this?

Thanks

[lfpm062010]

Try this, called the table [TABLENAME]

SELECT TABLENAME.Date, Sum(TABLENAME.QTY) AS Totals
FROM TABLENAME
WHERE (((TABLENAME.[Delivery method]) Like "*C"))
GROUP BY TABLENAME.Date;

[June7]

You want the summary by hour or total for the day?

Is the Time Confirmed a date/time field? Usually best to keep all parts of date/time in a single field. The parts are easily extracted with date/time functions.

[jdrumgold1983]

Hi June7,

Thanks for your reply, managed to get it to do what I wanted!

I'm wanting it per hour of the day and I have managed to round up the hours and group them together.

Thanks again