I'm starting to get the hang of this Access. But...Im stuck with another program. Ive made a quarie wich show me future reservation (adapting to the current date) so far so good. But now I want to show the dates per client on which he arives. EG. Mike has 3 reservations (future) and I want to show the dates on wich he arrives.
This is what I did: I made a querie in which the reservations (future ones) are shown. Then a # total(whatever you call it..Im Dutch so I dont know what to call it), so the querie gives me the number of future reservation (1,2,3,4, or 5). Then I put arrival date and total "first". Then I put arrival date again, but now with criteria: number>1, and again total "first"Is this the right way to do it?
Thanks. O yeah. If this isnt the forum for newbies....please tell me.
This is what I did: I made a querie in which the reservations (future ones) are shown. Then a # total(whatever you call it..Im Dutch so I dont know what to call it), so the querie gives me the number of future reservation (1,2,3,4, or 5). Then I put arrival date and total "first". Then I put arrival date again, but now with criteria: number>1, and again total "first"Is this the right way to do it?
Thanks. O yeah. If this isnt the forum for newbies....please tell me.