an expression query

  • Thread starter Thread starter Alan
  • Start date Start date
A

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
 
I have got a data base in excel 2007 which I have imported into access 2007
Click to expand...

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.
Click to expand...

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
Click to expand...

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]
 
Back
Top