Access Database Query

need some logic help please..

[SuzyUK]

Scenario:
@20 names with personal details:

One table consists of...
Name:
Address: (memo field)
Town:
Postcode:
Tel:
E-mail:

This is linked (relationship) to another table which details persons position in company i.e. chair, vice etc..

Problem:
I need to always display the name of the person associated with the position, but it's going to be the individuals choice as to what other details are publicly displayed i.e. it could be any combination of the other five fields.. although all fields are completed in the database.

how would I set up such a query.. thought it would help to get up early to think about this, but it hasn't..

Thoughts?

Suzy

[deejay]

Sounds like for each of those optional-display fields you need to have a yes/no field where the person can select whether the data is to be displayed.

Your query to display the data then becomes an IIF statement along the lines of

IIF [showtown]="true",[town],""

I only develop offline databases though, so don't know about web enabling it.

[SuzyUK]

deejay... Thank You!

that is exactly it.. I didn't know about iif, but I do now ;)

Web enabling it is OK, I can do that bit

Thanks again
Suzy