IIf statements- searching for duplicate records.

W

Weezie1383

Hi,

I'm hoping for some help in regards to a job which has just landed on my
desk. I have been given an Access database in which there are two tables. A
table which lists documents which exist as electronic versions, and a table
which lists documents which exist as hard-copies. My company is looking at
digitising the documents which are currently only hard-copy and so my boss
wants me to see whether the documents which have been listed as hard-copy
have a corresponding record in the electronic copy table. If they do then we
don't have to worry about digitising them because they already exist.

There is no relationships between the two tables- it looks like someone
simply imported Excel spreadsheets and saved them as tables.

I want to run a query which will look at each document number in the Hard
copy table and check to see if there is a corresponding document number
somewhere in the DocNumberElect field of the Electronic. I'm not exactly an
Access (or Excel) genius but I think I should be using some kind of IF
statement. Something like

IIF([DocNumberHC]=[DocNumberElect],"Multiple Media","Hard-Copy Only")

Any ideas would be greatly appreciated
 
W

Weezie1383

Nevermind......I answered my own question. Thank goodness for the find
unmatched query wizard!!
 
G

GARCIASREMODELING

Weezie1383 said:
Hi,

I'm hoping for some help in regards to a job which has just landed on my
desk. I have been given an Access database in which there are two tables. A
table which lists documents which exist as electronic versions, and a table
which lists documents which exist as hard-copies. My company is looking at
digitising the documents which are currently only hard-copy and so my boss
wants me to see whether the documents which have been listed as hard-copy
have a corresponding record in the electronic copy table. If they do then we
don't have to worry about digitising them because they already exist.

There is no relationships between the two tables- it looks like someone
simply imported Excel spreadsheets and saved them as tables.

I want to run a query which will look at each document number in the Hard
copy table and check to see if there is a corresponding document number
somewhere in the DocNumberElect field of the Electronic. I'm not exactly an
Access (or Excel) genius but I think I should be using some kind of IF
statement. Something like

IIF([DocNumberHC]=[DocNumberElect],"Multiple Media","Hard-Copy Only")

Any ideas would be greatly appreciated
Click to expand...
 
Top