Query update

[markymark71]

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

 

[spikepl]

How about explaining the desired ultimate point/benefit of this without any technical mumbo jumbo?

 

[Gasman]

Why not just group on Artiste or Artiste ID if you add that in the query?

 

[markymark71]

I want to be able to produce a report with a unique ref that contains a selected number of records that is calculated between two dates and a certain field.