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

URGENT PLEASE HELP ASAP. Date/ Time multiplied by a cost for a certain field? PLEASE.

P: n/a
Hello there
I wonder if you can help me.
I am creating a loans system for a make-believe CD rental company, in Microsoft
Access.
I have 3 tables: CD details, Member Details, and Loan Details.
I have created forms for each, so the user of the system can view member
details, enter new members, view loan details, enter new loans, etc.
A main menu [form] has also been created so the user can easily access the
three forms from this page.
However, within the CD table, there is a column called "CDPricePerNight".
Within this column, is a specific cost for each Cd, per night.
In the Loans table, there are columns for "LoanDate" and "ReturnDate", and a
final column for "TotalCDPrice".
In this Total CD Price column, I need a formula or some way of it automatically
calculating the number of nights between Loan Date and Return Date, and then
multiply this value by the cost for that particular CD.
Please help me if you can. I have included some screen prints of various
aspects of my system as it stands. And please also tell me where to put the
code or whatever it is I need to do!

<img src="http://www.angelfire.com/rock3/emy0/HelpPlease.JPG "</img>

http://www.angelfire.com/rock3/emy0/HelpPlease.JPG

Picture 1 is the design view of my Loans table.
Picture 2 is the form for the Loans.
Picture 3 shows the relationships between my tables.
Picture 4 shows the table for CD Details.

Thank you for your time!
Emy
<3
xoxo

Please email any replies to:

av*************@aol.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
See the DateDiff function.

On 26 Jan 2005 20:47:40 GMT, av*************@aol.com (AvrilComplic8ed) wrote:
Hello there
I wonder if you can help me.
I am creating a loans system for a make-believe CD rental company, in Microsoft
Access.
I have 3 tables: CD details, Member Details, and Loan Details.
I have created forms for each, so the user of the system can view member
details, enter new members, view loan details, enter new loans, etc.
A main menu [form] has also been created so the user can easily access the
three forms from this page.
However, within the CD table, there is a column called "CDPricePerNight".
Within this column, is a specific cost for each Cd, per night.
In the Loans table, there are columns for "LoanDate" and "ReturnDate", and a
final column for "TotalCDPrice".
In this Total CD Price column, I need a formula or some way of it automatically
calculating the number of nights between Loan Date and Return Date, and then
multiply this value by the cost for that particular CD.
Please help me if you can. I have included some screen prints of various
aspects of my system as it stands. And please also tell me where to put the
code or whatever it is I need to do!

<img src="http://www.angelfire.com/rock3/emy0/HelpPlease.JPG "</img>

http://www.angelfire.com/rock3/emy0/HelpPlease.JPG

Picture 1 is the design view of my Loans table.
Picture 2 is the form for the Loans.
Picture 3 shows the relationships between my tables.
Picture 4 shows the table for CD Details.

Thank you for your time!
Emy
<3
xoxo

Please email any replies to:

av*************@aol.com


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.