Make new table

[M8KWR]

Hi there, What i have is a query, which have a field called SOURCE, is this there can be anything from 2-6 different value.

what i require is to export this to excel, but create a new sheet for each different value in the source fields.

I know how to export this to excel via code, but i always thought that access used the name of the table/query for the sheet name.

What i was thinking was to create a loop which created the tables, and then export them to a certain excel file/path, adn then the name of the table/query would be the name of the sheet within excel.

I know i could create a query for each value in the source field, but these value could change, and i'm tryin to work out a procedure that is dynamic.

I hope i have explained myself ok, if not please let me know.

 

[JerryKlmns]

In VBA, create a recordset to retrieve all values of this field. Loop till the rs.EOF and for each value use a special query in the database. That query should be exporting all records of the table the way you like (formating, ordering, etc).Grab the sql of the query add a WHERE clause filtering for the value of the recordset and then export that query!