How do I write a conditional expression in access?

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

Guest

I need to write a conditional expression that includes comparing information
in three fields that might not necessarily be in the same record (line) and
then returning information in one of the fields based on the comparison...any
ideas?
 
I need to write a conditional expression that includes comparing information
in three fields that might not necessarily be in the same record (line) and
then returning information in one of the fields based on the comparison...any
ideas?
Click to expand...

I do not understand your question. Could you give an example of
typical data and the desired result? If you have an arbitrary number
of records, how do you determine which record should be compared with
which other record?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
m_elysia said:
I need to write a conditional expression that includes comparing information
in three fields that might not necessarily be in the same record (line) and
then returning information in one of the fields based on the comparison...any
ideas?
Click to expand...

Sounds like a self-join but you need to explain a bit more.

MC
 
Dear m_elysia:

Typically, I would be using a correlated subquery to retrieve
information from a row that is not necessarily the same row to make
the test and to return information from that row.

Your details are too scant to give you more information at this time.
If you require more information, please provide some sample data and
expalanation of how this must work.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top