Make Table Query Issues

[spectrolab]

Hi Everyone,

I have done a search for this and can't find anything (doesn't mean it isn't there)

I have a make table query that grabs data from 4 tables and brings them together to generate a text file for reporting to customers. The temporary table made is then deleted once reported.

My question is, is there any way to add a field to the newly made table that is the sequence of the row in the the table based on my sort criteria in the query? The new field will be called Sequence Number and the first row will have the value of 1, the second row value 2, etc.

Many thanks for any help you can give, please let me know if I haven't explained it well enough.

 

[raskew]

Hi -

You won't be able to complete this from the make table query. However, there is a way, using VBA, to add fields.

See: http://support.microsoft.com/default.aspx?scid=kb;en-us;210405

HTH - Bob

 

[spectrolab]

Thanks very much Bob,

Just what I was looking for.