Search results

Thanks for the reply and suggestions. Will have a look at that during the day.

I have been trying crosstab queries without success. I would be grateful if anyone could give any more pointers or guidance. I only need the date field, no others. My all allincidents query gives me all dates from Feb07 to today My 2007 dates query is >#31/01/2007# And <#01/01/2008# My...

Thanks for the replys. Will have a go at the crosstab query. Other than input my incidents I have not done anything else in Access before so I may be back!!

Thanks for your reply. However, I cannot seem to get a query to give me dates for 2007 and 2008 as two separate rows, I can only do each year separate or as one total. Is there a way a Query can be written to show dates from 2007 and 2008? I have tried......unsuccessfully Thanks

Hi, I have done a search before posting but cannot find what I am looking for. At work I use a database to record incidents (work that I do). I have written a query for incidents for 2007 and 2008 and I can do a line graph for each year showing the monthly incidents by doing Insert, Form, Chart...