Graphing differences in Dates

[silversurfer19]

Hello,

I am trying to graph differences in dates between when two different companies both last verified their version of data on an address, in terms of which is the most recent. I have used the date difference function in order to determine the difference in days between the two dates for each record, which I want to be the horizontal axis, but (I think) I want the vertical axis to be a count of the number of instances of each date difference, and I don't know how to go about doing this. I've tried the Count function but it just counts the number of records overall...

Thanks in advance for any help

 

[jzwp22]

I haven't done much with graphing in Access, but to get the count, I would suggest creating another query based on the query that calculates the difference

SELECT differenceField, Count(differencefield) as myCount
FROM yourquerythatcalculatesthedifference
GROUP BY differenceField

I think you should then be able to base your graph on the above query.

 

[silversurfer19]

Thanks, I've managed to get the count doing something similar, and have created some bar charts which look like they're what I want, though they're not particularly neat. Think I'm managing ok for now, but I may need to post more in this thread as I discover other graphing problems.

Ta for the help

 

[jzwp22]

Glad to hear that you got it worked out!

 

[johnwatkins35]

can you post your DB?