Query update

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

Query update