move Values (Alpha), from Table to Form

  • Thread starter Thread starter Lumen
  • Start date Start date
L

Lumen

I am importing a large Excel file in to a new table. The addresses that I
want to extract from the table and pass to a Form, via a Queries file, have a
unique identifier. However this identifier could be in one of 9 different
columns in 9 records; in each case the identifying cell is followed by 8
cells giving the complete postal address. I can quite easily use 'Criteria'
to pull out the bits of the record that I need but I'm not sure how to pass 9
different cell/field references to one 'Control Source' in my 'Form'.
 
Lumen said:
I am importing a large Excel file in to a new table. The addresses that I
want to extract from the table and pass to a Form, via a Queries file,
have a
unique identifier. However this identifier could be in one of 9 different
columns in 9 records; in each case the identifying cell is followed by 8
cells giving the complete postal address. I can quite easily use
'Criteria'
to pull out the bits of the record that I need but I'm not sure how to
pass 9
different cell/field references to one 'Control Source' in my 'Form'.
Click to expand...
 
I am importing a large Excel file in to a new table. The addresses that I
want to extract from the table and pass to a Form, via a Queries file, have a
unique identifier. However this identifier could be in one of 9 different
columns in 9 records; in each case the identifying cell is followed by 8
cells giving the complete postal address. I can quite easily use 'Criteria'
to pull out the bits of the record that I need but I'm not sure how to pass 9
different cell/field references to one 'Control Source' in my 'Form'.
Click to expand...

Well... generally, don't. Copying data from one field into another field and
storing it redundantly is essentially never a good idea!

Instead put a criterion on all eight fields (not "cells" please), on separate
lines on the query grid so that it uses OR logic.

I'm not clear on the structure of your spreadsheet though: you have a unique
identifier, but you have no way to predict where it is?? Could you post a
sample of the data and point out what it is you're trying to find?
 
Back
Top