sql for access query

[marleyuk]

Im importing a file into access and i want to add querys. The problem is the field im querying wont always be in the same place or be the same name. The only thing that remains the same is that the field i want to query will always be the last column. Anyone know what to do for this??

Thanks
Marley.

 

[FoFa]

Create a static table (always the same) then import files into a work table (changes depending on the import format) and then move the columns from the work table to the static table. Use your static table to query against.