2 Identical tables in one query

[steve1111]

hi,

i have a read-only link into a SQL db from Access that holds all of our ride records. in that db the designer has a tblRides that maxed out at 1.2 million records, so he had to create a tblRides2 table. All of the fields are identical and the ID in each respective table starts at 1.

i have a form with user inputs for date frame and specific driver. Is there a way to have that query search both tables for that criteria?

I have some VBA experience but sill a beginner.

thanks

 

[CJ_London]

you could use a union query to combine your two tables but this could be quite slow. Or better to have two separate 'search' queries which are then unioned to provide the results

However I would look at your table design. 1.2m records is not that many records - I suspect your designer has not normalised the design. Maximum number of records is dictated by the maximum size of a db (2Gb) less the space required for other objects

 

[steve1111]

Thanks CJ i will give the two separate searches and combining them a go.