Querying tables with multi combo boxes

S

souchie40

Hi all, I have a wee problem with my DB that I hope someone can help with, I
have a table called Engines this is linked to another table with 4 fields in
combo box style, this is because each type of engine can be used for a
different purpose

What I want to do is be able to run a query of some sort that would allow me
to add each individual type of engine together so that I can then generate a
report that would show the protential sales of each type.

In the relentionships view the engine table is replicated 3 times to form
the relationships for the combo boxes.

Many Thanks In Advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top