How to Get FieldName as Value

[hlubpc09]

I have two table (created by someone else). One contains the date, order number, customer name, etc. The other table contains the test methods perform and it store values. click on url.

I create a query (to be used as report later) and would like to use the 'Field Name' such as 'Abrasion(fabric)' instead of 1 as value.

Can someone help?

thanks

 

[Remou]

It seems that a look-up field has been used in your table. This is not recommended. The best solution would be to make the field a normal numeric field and to create a a look-up table for the text description, if one does not already exist. You could then build queries for use in forms etc that join the two tables.

http://lessthandot.com

 

[PHV]

Have a look here:

http://www.mvps.org/access/lookupfields.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hlubpc09]

ok. Then in the 'control source' when create a report, is it possible to write a simple code that says if the values of the field name is not empty (no matter what values it is in it); then write 'abrasion'. if the field name value is empty then don't write anything.

I try this code:

=IIf([abrasion] <> "", "Abrasion")

when i run the query, on the text field; it says "#error"

thanks

 

[PHV]

And this ?
=IIf(Trim([abrasion] & "") <> "", "Abrasion", "")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hlubpc09]

Still got the same error message. I already check in the database to be sure that I do have data in it and it does. any other ideas?

Thanks

 

[lespaul]

well according to your picture the field Abrasion (fabric) is a number....you can't compare a number to an empty string (which is what "" is)....
maybe:

iif([Abrasion (fabric)] = 1, "Is One", "Not One")

Leslie

Have you met Hardy Heron?

 

[hlubpc09]

Thank you! It works!

 

[hlubpc09]

ignore the attach url. got it to work.