6 results in same day display in graph

[caramon00]

i am trying to take a query that currently is pulling the user name from a directory that holds all users against a user log on for different sites for who is on the system at the snapshot time but cannot seperate the date from the time and get the graph to display properly. but when i use this query i get the data i want displayed but trying to display it in a chart i only show the date and total of that date not seperated by the times, which are pulled at 10:10, 11:10, 12:10,13:10, 14:10 and 15:10 from the server itself for who is logged in currently.

SELECT Directory.Warehouse
   , User3.[date/time]
   , Count(User3.ID) 
      AS CountOfID
FROM Directory INNER JOIN 
      User3 
   ON Directory.[User ID] = User3.ID
GROUP BY Directory.Warehouse
   , User3.[date/time]
HAVING (((Directory.Warehouse)="11"));

[zmbd]

First I strongly advise you to rename your [Date/Time] field if possible...

-alphanumeric:
Access 2007 reserved words and symbols
AllenBrowne- Problem names and reserved words in Access

If this is from a server, then your DBA has done you no favors in using reserved words and symbols and IMHO should be sent back to remedial database design.

If the query is displaying the correct information, then (not to state the obvious :-D ) something in the chart formatting may be off.
Open in design mode.
Right click the axis in the chart
Select formt axis from the pop-up menu
Set the scale and the number formating

yea.