Query help

[JCtheEUC]

Hello,
I am trying to build a query in Access that will display all public notes and private notes set by the logged in individual.

EX. logged in user is 1234
query will show:
USER --NOTE -----SENSITIVITY
1234 --Hi----------Public
8765 --Bye--------Public
1234 --Goodnight--Private
9876 --Later-------Public

Show all public results and only Private results by the user.
I'm not sure if this is possible or not. any assistance would be great!

Thanks

 

[jackd]

Please show your table structure.

 

[JCtheEUC]

Sorry.
The table contains ID(autonumber), User(string), Note(string), Sensitivity(string).

 

[JCtheEUC]

This query has been resolved. All I needed to do was do 2 seperate AND statements seperated by an OR in the where clause. It's Friday...ready for the weekend.