Limiting YTD totals to date

  • Thread starter Thread starter Dragon
  • Start date Start date
D

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
 
The database only contains one year's data so before 5/1/2008 would be fine
too.
Dragon

Golfinray said:
Do you mean like Between 1/1/2008 and 5/1/2008?

Dragon said:
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
Click to expand...
Click to expand...
 
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
 
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

Jeff Boyce said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top