Table configuration to run query based on gender state political party or district sort will provide

[ZumbaLady]

How to set up tables to run the following queries
Identify the records by gender state result name and identification number with a photo
Run a query to find everyone from the state who is in the same political party
Run query to sort names and identification numbers pictures by


District number state and gender
Can this be done I have information on excel sheets but how do I define the relationships to get the data I want ?

[ranman256]

you can attach the XL files as tables.
then build all the queries you mentioned.
I don't see the need for relationships. All the demo data should be on each record.
bob smith, male, democrat, TX

[ZumbaLady]

Well I have operators who need to identify people based on knowing only some of that information and I thought a query may be written that would sort records based on knowing only two or three factors