Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
php95saj
Starting Member
43 Posts |
 Posted - 2003-03-23 : 02:41:20
|
| I have four tables in an access database 1 tblRoomType roomTypeID (PIK) roomTypeDesc (text) 2 tblRoomSize roomSizeID (PIK) roomSizeDesc (text) 3 tblHolidayPeriod holidayPeriodID (PIK) startDate (date/time) endDate (date/time) holidayPeriodDesc (text) 4 tblRates rateID (PIK) roomTypeID (number) roomSizeID (number) holidayPeriodID (number) rate (currency) I have a form in which user can select room size, start and and end date and I have to give the user prices for three different types of room for that room size for that period. I cann't get this into my head. Can anyone help? TIA Sharjeel |
|
|
darinh
Yak Posting Veteran
58 Posts |
Posted - 2003-03-23 : 16:03:20
|
| You should probably ask your question as part of the thread you originally started on it [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24632[/url]. You got some some good answers - if you're confused about them, you should reply, not start a new thread. |
 |
|
|
|
|
|
RE: A Query in access