an expression query

[Alan]

I have got a data base in excel 2007 which I have imported into access 2007
The data base contains Hotels, prices and clients names and addresses.
What do I have to do to show a discount when clients stay in an hotel for 3
or more nights
Someone told me that I should use an expression query
Please help
Alan

 

[John W. Vinson]

I have got a data base in excel 2007 which I have imported into access 2007

Not quite. You have a spreadsheet in Excel which you have imported into a
table in Access.

The data base contains Hotels, prices and clients names and addresses.

All in one table? You need to actually convert this spreadsheet into a table,
then. You should have AT LEAST three tables, probably more: Hotels; Clients;
HotelStays for example.

What do I have to do to show a discount when clients stay in an hotel for 3
or more nights
Someone told me that I should use an expression query

Without knowing anything about the structure of your table, fieldnames, etc.
it's impossible to give specific advice... but you should certainly start (if
you haven't done so already) by normalizing the data into relational tables.

John W. Vinson [MVP]