I
instereo911 via AccessMonster.com
Good afternoon,
I am having trouble w/ a query. I set up a query w/ the following code:
SELECT [A-GATotalInventory].Date, [A-GATotalInventory].UnitAssociate, [A-
GATotalInventory].Manager, [A-GATotalInventory].Name, Count([A-
GATotalInventory].AgedDays) AS TotalInventory, Max([A-GATotalInventory].
AgedDays) AS OldestItem, Count([A-GATotalInventory].AgedDays) AS
CountOfAgedDays
FROM [A-GATotalInventory]
GROUP BY [A-GATotalInventory].Date, [A-GATotalInventory].UnitAssociate, [A-
GATotalInventory].Manager, [A-GATotalInventory].Name
HAVING (((Count([A-GATotalInventory].AgedDays))>30 Or (Count([A-
GATotalInventory].AgedDays)) Is Null));
My problem of the last statement. My goal is to group by Date, group by Unit
Associate, group by Manager, group by Name, Count the amount of ageddays and
then on the same query count the aged days that are over 30. My problem is
that some of the Unit Associate (names and managers) may not have any over 30
but may still have some of the countofaged AND THE QUERY won't show a zero if
there is none on it. Should I set up another query? What should I be doing. I
am not too expierenced w/ access so any helpful hints on what do would be
great!!!!
Thank you everyone
I am having trouble w/ a query. I set up a query w/ the following code:
SELECT [A-GATotalInventory].Date, [A-GATotalInventory].UnitAssociate, [A-
GATotalInventory].Manager, [A-GATotalInventory].Name, Count([A-
GATotalInventory].AgedDays) AS TotalInventory, Max([A-GATotalInventory].
AgedDays) AS OldestItem, Count([A-GATotalInventory].AgedDays) AS
CountOfAgedDays
FROM [A-GATotalInventory]
GROUP BY [A-GATotalInventory].Date, [A-GATotalInventory].UnitAssociate, [A-
GATotalInventory].Manager, [A-GATotalInventory].Name
HAVING (((Count([A-GATotalInventory].AgedDays))>30 Or (Count([A-
GATotalInventory].AgedDays)) Is Null));
My problem of the last statement. My goal is to group by Date, group by Unit
Associate, group by Manager, group by Name, Count the amount of ageddays and
then on the same query count the aged days that are over 30. My problem is
that some of the Unit Associate (names and managers) may not have any over 30
but may still have some of the countofaged AND THE QUERY won't show a zero if
there is none on it. Should I set up another query? What should I be doing. I
am not too expierenced w/ access so any helpful hints on what do would be
great!!!!
Thank you everyone