Contolling which Table is used

  • Thread starter Thread starter Jason Rhymes
  • Start date Start date
J

Jason Rhymes

Is there a way to control which table is used in a report other then
changing it in design view - Record Source.
 
Why are you adding tables instead of appending records to ONE table? Addind
tables makes it very hard to work with your data (as you've learned).

I'd recommend adding records to your single table, not adding new tables.

Rick B
 
I understand that by default it creates a new table. My question is, Why
don't you then grab the records from the imported table and merge them into
your primary table, then delete the temporary table. This is how most
people would handle data that is imported on a regular basis. You (of
course) would want an Import Date field in your table if you will need to
know when the records were imported. You could use this field as criteria
in your report. One big advantage here is that you could then report off of
all the data, or just some of the data.




Rick B
 
Well, that makes more since. The only problem I have with merging the data
is once it's merged I won't know where the data came from. MDT doesn't send
any unique identifier to segregate it form the rest of the data other then
the table name. If I could merge it with the table name as a new field, then
it would work.
 
Back
Top