IIf statements- searching for duplicate records.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Nevermind......I answered my own question. Thank goodness for the find
unmatched query wizard!!
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
IIf statement Query 17
IIF Statement - Query Help Needed 1
IIF statement 1
Iif Statement 2
IIF statements 1
Sum(IIF statement 1
Searching for parent in child-parent table 5

Back
Top