Hi, I created a query that takes information from a bookings table which contains bookings for artistes and dates they are performing, I have used a start date, end date and ArtisteID in the criteria which is generated via a form that I've created.
This gives me an artistes dates between a specific range of dates.
Is there any way of saving this query result to a unique ID number, so when I create a report it will have several dates for one artiste with one ID i.e..
Ref: 01
1/3/15 artiste venue fee
14/3/15 artiste venue fee
21/3/15 artiste venue fee
I have tried an update query and created a separate table with a outnumber but obviously this creates a ID number for each date
Hopefully someone can help me as I've been at it all day :banghead:
Mark
This gives me an artistes dates between a specific range of dates.
Is there any way of saving this query result to a unique ID number, so when I create a report it will have several dates for one artiste with one ID i.e..
Ref: 01
1/3/15 artiste venue fee
14/3/15 artiste venue fee
21/3/15 artiste venue fee
I have tried an update query and created a separate table with a outnumber but obviously this creates a ID number for each date
Hopefully someone can help me as I've been at it all day :banghead:
Mark
Query update
