Table Structure and Linking

[solnajeff]

I am writing a database for use in a casino and am looking for some advice regarding the linking of tables.

Generally everything is fine apart from the creation of a query which returns duplicate values which I think is due to the way I have structured the data.

There are three linked tables, customers, daily win/loss data and games played. Customers and win/loss are linked on customer ID and win/loss and games played on record ID.

Entering and viewing data via form is fine and everything works well however the problem is to create a query that returns win/loss records that match specified criteria.

I am not sure if I need to take a different approach and incorporate the games played into the win/loss table.

Although I have a fair amount of experience with Excel and VBA I am new to Access and would appreciate your advice.

Many thanks

Jeff

 

[CJ_London]

The standard query 'profile' is

SELECT whateveryouwant 
FROM thistable INNER JOIN thattable ON thistable.somefield=thattable.someotherfield 
WHERE yetanotherfield=somethingorother

 

[solnajeff]

hi

I apologize for the delay in replying, but have been out in the jungle with no internet for a few weeks. I will look at restructuring the table I think and take it from there.

Thanks to all for your advice.

Regards

Jeff

 

[milkman2500]

If your queries are returning duplicate values, you can use the "unique" feature of a query.