advice on a formula possibly

[Sharon]

Hi i have created a database in access 2000 one of my tables holdes
accommodation details including costs. what i have just realised is that all
accommodation has different rates for different periods ie a b & B can cost
£10 per night and Self catering accommodation can cost £340 per month so i
have added extra fields for us to enter in how long the duration of the stay
will be. I have set the properties to text because i was not thinking about
it properly and now realise that i need some way to indicate how much the
over all cost will be ie Joe Bloggs stayed in self catering accommodation for
7 weeks and Mary Bloggs stayed in a B&B for 3 days.

Could anyone tell me firstly what properties i should set the field too (i
am assuming its number)
secondly how can i calculate the amounts in my reports/queries

regards
Sharon

 

[rpw]

It would be helpful if you posted a bit more about the table and the fields.
Without knowing what you have, everyone here is left guessing and therefore
cannot help to well. Here's a sample of how you might supply the information:

tblAccomodations
AccomodationID (PK - primary key)
AccomodationType (text)
AccomodationRate (number-double,format=currency)
AccomodationPeriod (text)
etc....

and then some sample data:

ID Type Rate Period
1 B&B 10 Day
2 SelfCat 340 Month
etc...

Please don't take the above as a suggestion on how to design your tables -
it is only there for how to post some information about how your tables are
currently setup. With that, hopefully someone here can help you.