linking fields to show only true values

[briandavis]

In my database I have a table for my daily schedule. In this table for example one of the scheduled places to work is the "frontdesk". The value for this field is a name pulled from a query on the employees table. On the form created for the schedule table I have a check box next to each area and when checked it tells me if the person working this spot is on overtime. Additionally on my schedule table I have a yes no field ie "frontdeskot" that tells if ths spot was ot or not.

I need to track which spots are having all the overtime on each day. I want to create a report that will just show me what spot was ot on that day and who worked it. Everytime I try t set it up it shows me everything. I do not want to see the other stations again only the ones for OT. Should I do a query first and then again how would I get it to show me only the results i want.

Any help will be appreciated. This is the last piece of the puzzle. After this my DB is done.

Thanks

 

[Pat Hartman]

You need a query that selects records where OT is true.

 

[briandavis]

Sorry, I went on vacation just after my initial post. I can run the query for true values. What I can't figure out is if the value is true how do i get it to displaythe value of a different field as well

 

[Pat Hartman]

If you are only selecting records whose value is true, you would always display the other field.

If you don't want to use selection criteria but just want a field to show or not show based on another value, use an IIf().

Select ...., IIf(IsNull(fldA), fldB, null) As SomeOtherField, ....

 

[briandavis]

item solved

yea that's right. I guess my vacation scrambled my brain.

Thanks again!