Help me please!

[Divatox]

Ok...here goes.

I have a big table that I need specific information
from. I know how to do queries, but I was wondering if I
could do something specific in a query.

Sample table:
Name Job Title Relationship Award1 Award2 Award3
Joe Sales Mgr X X
Lisa wife
Mary Sales Rep X
Mike husband
Rob Sales Rep X X
Sara wife
Martin CEO
Bill President


Here's the problem...the spreadsheet that I have is
almost 1,000 people. I want to create a new table with
the Award winners only. As you see, they all don't win
the same awards, so I need to create a query that will
include all award winners. How do I create a query to
give me the information for only Joe, Mary and Rob.

This conference is a yearly thing and I don't want to
create a new table with that information and then have to
go through the 1,000 names and delete all the family and
other non-award winners.

Can anyone help me?

 

[Rick B]

Build a query. On the first line specify that [award1] is true. On the
second, specify that [Award2] is true, etc. Each line in the query is an
"OR" statement.

Rick B



Ok...here goes.

I have a big table that I need specific information
from. I know how to do queries, but I was wondering if I
could do something specific in a query.

Sample table:
Name Job Title Relationship Award1 Award2 Award3
Joe Sales Mgr X X
Lisa wife
Mary Sales Rep X
Mike husband
Rob Sales Rep X X
Sara wife
Martin CEO
Bill President


Here's the problem...the spreadsheet that I have is
almost 1,000 people. I want to create a new table with
the Award winners only. As you see, they all don't win
the same awards, so I need to create a query that will
include all award winners. How do I create a query to
give me the information for only Joe, Mary and Rob.

This conference is a yearly thing and I don't want to
create a new table with that information and then have to
go through the 1,000 names and delete all the family and
other non-award winners.

Can anyone help me?

 

[Divatox]

Thank you Rick! You just made my day.

Heidi