By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,326 Members | 1,938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,326 IT Pros & Developers. It's quick & easy.

Select a unique value based on several variants

P: 1
Hi,

I am working with MS Access and I am trying to select a value for a golf green fee from a table called "tblgreenfee".
The table has several variables, [month],[No of Holes],[Day of the Week] which changes the green fee charged. So playing on a Monday in April say 36 holes will undoubtedly have a different cost to playing on a Saturday in July over 18 holes. The table "tblgreefee" has all data entered for each month, combination of holes and days of the week (over 300 records).

What I want to achieve is to be able to use a seperate form called "frmbooking" to enter a date, no of holes being played and for the green fee to be automatically selected and entered on the form in the text box "txtgreenfee".

One added complication. Entering a date in the form does not relate to the "month" field in the "tblgreenfee" as I had to enter the month in the table "tblgreenfee" as text.I have spent hours trying to figure this out but to no avail!

Thanks to anyone who can help!
Ralphie
Oct 10 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
PEB
Have you any idea how to construct your queries... What is the difficult in the query that is a problem?

Best regards
Oct 14 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
you could try this:

Month(DateValue([tblGreenFee].[Month]))

DateValue should impose a valid date using the text value in Month

Month will then convert it to the required Month value
Oct 14 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.