Limiting YTD totals to date

[Dragon]

I have a query that totals lbs and pieces year-to-date (YTD).
However, I need to be able to limit the query to the total up to a user
specified date.
I've tried <[tomorrows date] but it simply returns the daily totals.

Thanks in advance,
Dragon

 

[Golfinray]

Do you mean like Between 1/1/2008 and 5/1/2008?

 

[Dragon]

The database only contains one year's data so before 5/1/2008 would be fine
too.
Dragon

Do you mean like Between 1/1/2008 and 5/1/2008?

I have a query that totals lbs and pieces year-to-date (YTD).
However, I need to be able to limit the query to the total up to a user
specified date.
I've tried <[tomorrows date] but it simply returns the daily totals.

Thanks in advance,
Dragon

 

[Jeff Boyce]

It all starts with the data, and you've not described what you are storing
and in what structure...

"How" depends on the data.

By the way, please post the SQL statement of the query you are using now ...
it may provide clues.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dragon]

The database is tracking shipping and receiving out of a warehouse. The
reports I'm working on show the daily total weight, pieces and number of
trailers loaded and unloaded for each area as well as a running year-to-date
(YTD) total of each number.

One of the queries is:
SELECT [PCS / Bulk Ship].Warehouse, Sum([PCS / Bulk Ship].ActualWeight) AS
TotalWeight, Sum([PCS / Bulk Ship].ActualPieces) AS TotalPieces, [PCS / Bulk
Ship].Export
FROM [PCS / Bulk Ship]
GROUP BY [PCS / Bulk Ship].Warehouse, [PCS / Bulk Ship].Export
HAVING ((([PCS / Bulk Ship].Warehouse)='Bulk'))
ORDER BY [PCS / Bulk Ship].Export DESC;

Thanks in advance,
Dragon

It all starts with the data, and you've not described what you are storing
and in what structure...

"How" depends on the data.

By the way, please post the SQL statement of the query you are using now ...
it may provide clues.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a query that totals lbs and pieces year-to-date (YTD).
However, I need to be able to limit the query to the total up to a user
specified date.
I've tried <[tomorrows date] but it simply returns the daily totals.

Thanks in advance,
Dragon