If Statement??

[kimtorvinen]

Hello,

I'm wondering if anyone can help me create a query statement for a
registration database I'm working on. The query goes like this....

"Event ID" (name of event) "Last Name of Attendee" "First Name of
Attendee" and "Workshop attended" as a yes/no data type.

Would I create this as:

If If Attendee.[Workshop attended by attendee] = "yes" then
Select [ Attendees.AttendeeLastName] and [Attendees.AttendeeFirstName]

I want to be able to create a report out of this query.

Thanks for all your help!

Kim

 

[akphidelt]

First off, if in Access is IIF so it would go

Second off you would be much better of just putting "yes" in the query
criteria. Otherwise I do not get the point of this query statement.

 

[kimtorvinen]

First off, if in Access is IIF so it would go

Second off you would be much better of just putting "yes" in the query
criteria. Otherwise I do not get the point of this query statement.

Hello,

I'm wondering if anyone can help me create a query statement for a
registration database I'm working on.  The query goes like this....

"Event ID" (name of event)  "Last Name of Attendee" "First Name of
Attendee" and "Workshop attended" as a yes/no data type.

Would I create this as:

If If Attendee.[Workshop attended by attendee] = "yes" then
Select [ Attendees.AttendeeLastName] and [Attendees.AttendeeFirstName]

I want to be able to create a report out of this query.

Thanks for all your help!

Kim- Hide quoted text -

- Show quoted text -

Sorry I confused the question. I want to be able to show only the
names of those who did not attend the workshop.

So I would put "no' for false?

Kim

 

[akphidelt]

In the query criteria underneath Attendee.[Workshop attended by attendee]

You would put either "No" or 0 depending on what you are using for your
yes/no criteria.

First off, if in Access is IIF so it would go

Second off you would be much better of just putting "yes" in the query
criteria. Otherwise I do not get the point of this query statement.

Hello,

I'm wondering if anyone can help me create a query statement for a
registration database I'm working on. The query goes like this....

"Event ID" (name of event) "Last Name of Attendee" "First Name of
Attendee" and "Workshop attended" as a yes/no data type.

Would I create this as:

If If Attendee.[Workshop attended by attendee] = "yes" then
Select [ Attendees.AttendeeLastName] and [Attendees.AttendeeFirstName]

I want to be able to create a report out of this query.

Thanks for all your help!

Kim- Hide quoted text -

- Show quoted text -

Sorry I confused the question. I want to be able to show only the
names of those who did not attend the workshop.

So I would put "no' for false?

Kim

 

[Lance]

This should be handled in the "where" clause.

SELECT Attendees.AttendeeLastName, Attendees.AttendeeFirstName
FROM Attendees
WHERE Attendee.[Workshop attended by attendee] = true

 

[kimtorvinen]

This should be handled in the "where" clause.

SELECT Attendees.AttendeeLastName, Attendees.AttendeeFirstName
FROM Attendees
WHERE Attendee.[Workshop attended by attendee] = true

Hello,

I'm wondering if anyone can help me create a query statement for a
registration database I'm working on.  The query goes like this....

"Event ID" (name of event)  "Last Name of Attendee" "First Name of
Attendee" and "Workshop attended" as a yes/no data type.

Would I create this as:

If If Attendee.[Workshop attended by attendee] = "yes" then
Select [ Attendees.AttendeeLastName] and [Attendees.AttendeeFirstName]

I want to be able to create a report out of this query.

Thanks for all your help!

Kim- Hide quoted text -

- Show quoted text -

Thank you all...I was able to do this!

Kim