Probably a very simple problem

[Big Si]

Ok, I've created a customer/transaction database for a studio. It's very simple - five tables.

The studio wants a functionality whereby they can enter the criteria "X" and "Y" see example

e.g. customers that live in areas X or X or X or X and have bought products Y or Y or Y or Y - ("X" and "Y" drop-down lists, referenced from tables)

- then the database finds these records and produces them.

So - how can I create this. I havn't been able to figure out a way to get data from a form into the 'criteria' sections of a query.

As I said, its probably a really simple problem for anyone with access experience, but I'm stuck - can anyone help me?

 

[astarbyfar]

Lookup

Si is it a query or a basic table that you wish to use?

 

[Big Si]

Its a query - the data then needs to be exported to outlook for a mailing list.

 

[astarbyfar]

Query

In the field you wish to insert a look up (usually a foreign key) where you create it data type change it to lookup wizard. That should hopefully be able to help you

 

[MarkK]

Assuming you've not changed a form's default shortcut menu, try right clicking on a form and selecting the Filter By Form option. This allows you to enter filter criteria in various fields, and it also adds "or" tabs so you can enter different filter info in the same fields.
This gives you an instant ability to create a filter for customers who live in X or X, bought Y or Y, and did so April 1 or 2.

 

[dopedealer]

A very simple and basic example. choose the criteria and press search.
Chris