Query

  • Thread starter Thread starter Colin Hammond
  • Start date Start date
C

Colin Hammond

I have written:
Cardcat: IIf([category]="cadet","cadet","full")
Into a query, It doesn't work because "category" appears in two tables in
my database. What should I have written to identify the table I am refering
to.

Colin
 
Prefix the field with a
. identifier.

Cardcat: IIf([YourTableHere].[category]="cadet","cadet","full")
 
Thanks Danny. I thought I had tried that but must have made a typo.

Colin
Danny J. Lesandrini said:
Prefix the field with a
. identifier.

Cardcat: IIf([YourTableHere].[category]="cadet","cadet","full")
--

Danny J. Lesandrini
(e-mail address removed) http://amazecreations.com/datafast
Colin Hammond said:
I have written:
Cardcat: IIf([category]="cadet","cadet","full")
Into a query, It doesn't work because "category" appears in two tables
Click to expand...
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

Duplicate Record in Query then Report 3
Duplicate Record in Query then Report 10
Cascaded queries 2
Multiple Queries to Multiple Reports 1
Re Monthly Invoices 1
Cmd Btn to open Report W/ Specific Data 1
Categorize Continuous Variable into a Discrete One based on a table 1
If you miss Pinball... 7

Back
Top