Make Table

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I am pulling in data from a Mas90 ODBC database into a select query. Having
this query, what is the best way to get it written to a table? Make another
query? I am lost on the concept of where to do this. Records should be
selected by check date by the way.

Also, with data being grouped by date, is there a way to only write to the
table once so there is not a doubling of records? Or do they overwrite each
other????

thanks.
 
I am pulling in data from a Mas90 ODBC database into a select query. Having
this query, what is the best way to get it written to a table? Make another
query? I am lost on the concept of where to do this. Records should be
selected by check date by the way.
Click to expand...

You can simply use the Query menu option to convert this Select query
into a MakeTable (or, perhaps better, and Append query into an empty
table with your desired fieldnames and properties).
Also, with data being grouped by date, is there a way to only write to the
table once so there is not a doubling of records? Or do they overwrite each
other????
Click to expand...

You can use the "Unique Values" property of the Query; if you use the
append query approach, you can (instead or in addition) put a unique
Index on the date field to prevent duplicates. By default a MakeTable
query will append all the records you select, duplicates or not -
Access has no way of knowing which fields you want to allow or forbid
duplicate values!
 
Back
Top