Dear all,
I think I have created an unnecessary stir here, which was not my intention. So firstly apoligies for any confusion on my part.
Actually the last post sumerises what I am after. I am oviously getting a little confused as to how I go about acheiving this.
Also the reason I have not been online consistentely is that as part of my work I am requried to shift between sites etc.
Yes, I am very curious as to why I would actually have to use the +1 option when I just though I could have used some form of command instead. Also there is no time field in my data.
The query is needed to help me establish how many permits have been issued over a 5 year period. We currently have 3, 6, and 12 month periods, so I would like to group by the permit types.
When we issue a permit, we add the start date but the computer system calculated the end date, which when I add to Access produces this oddity as I am struggling to find out exactly how best to write a query that also includes the start and end dates.
If it is just a matter of using the +1 option that is fine.
Hopefully I have clarified matters a bit better now and by the way I am a 'he!'
Regards. Pari.