S
stmarystramp
Hello
I am completely new to this, so if you are kind enough to reply,
please remember that the language is unfamiliar.
This task seems mammouth to me right now, so I think that what I need
are pointers in the right direction, which I can then explore further.
Background
I will be distributing a database to various people. In it there will
be only 1 table. The 1st 3 columns of this table will contain the same
postcode but entered differently, as 7char, 8char, & 1 space.
The remaining columns will contain data relating to the postcode.
The people using the database will have a list of postcodes, either in
excel or csv or dbf. They will need to cross reference their files
with my Access table. The purpose of which will be to produce a report
from all the other fields of the table.
Help needed. To do the above I think I need something like:
A button which will open the file dialog and let the user find the
file anywhere on their computer.
Once this file has been located another button will initiate the
folowing:
Look at the postcodes contained within the located file & match them
to the 1st 3 postcode columns of my table.
Obviously, we cannot count a postcode twice as this would affect our
results, there will also be erroneous codes which will have to be
excluded.
Once they have been matched, a report will preview that gives a total
of all the other columns, but I really need to get this 1st bit
sorted, so will leave it there for now.
I am completely new to this, so if you are kind enough to reply,
please remember that the language is unfamiliar.
This task seems mammouth to me right now, so I think that what I need
are pointers in the right direction, which I can then explore further.
Background
I will be distributing a database to various people. In it there will
be only 1 table. The 1st 3 columns of this table will contain the same
postcode but entered differently, as 7char, 8char, & 1 space.
The remaining columns will contain data relating to the postcode.
The people using the database will have a list of postcodes, either in
excel or csv or dbf. They will need to cross reference their files
with my Access table. The purpose of which will be to produce a report
from all the other fields of the table.
Help needed. To do the above I think I need something like:
A button which will open the file dialog and let the user find the
file anywhere on their computer.
Once this file has been located another button will initiate the
folowing:
Look at the postcodes contained within the located file & match them
to the 1st 3 postcode columns of my table.
Obviously, we cannot count a postcode twice as this would affect our
results, there will also be erroneous codes which will have to be
excluded.
Once they have been matched, a report will preview that gives a total
of all the other columns, but I really need to get this 1st bit
sorted, so will leave it there for now.
have an awesome day