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

AvrilComplic8ed

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

Subscribe Post Reply

2009

Steve Jorgensen

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

Similar topics

Please Help with SQL

by: MSM | last post by:

Hello, This may be posted twice if so i apologize. I am creating a form using php where the information entered into the form will go into a database. When creating the tables in SQL where do I...

PHP

Urgent Questions regarding Index usage & VIEWs, sorting, etc.

by: Mike | last post by:

Hello, I have a few rather urgent questions that I hope someone can help with (I need to figure this out prior to a meeting tomorrow.) First, a bit of background: The company I work for is...

DB2 Database

Urgent rek

by: Radhesh Reddy | last post by:

One of our clients is in need of following consultants Business analyst with I2 background Location: Overland park,KS Duration: 6 months+ startdate: ASAP Description and Skills We are...

Microsoft SQL Server

urgent req with our Direct Client

by: swaroopa | last post by:

Hello Partner Please forward some good resumes with excellent communication skills. 1.REMEDY AR CONSULTANT Exp: 6-10YEAR Location: San Jose CA Duration : 2 Months

Microsoft Access / VBA

How to combine date and time in the database

by: Luvin lunch | last post by:

Hi, I'm new to access and am very wary of dates as I have limited experience in their manipulation and I know if they're not done properly things can turn ugly quickly. I would like to use a...

Microsoft Access / VBA

urgent

by: georges the man | last post by:

The purpose: • Sorting and Searching • Numerical Analysis Design Specification You are to write a program called “StockAnalyser”. Your program will read a text file that contains historical...

C / C++

best design for parse

by: gs | last post by:

let say I have to deal with various date format and I am give format string from one of the following dd/mm/yyyy mm/dd/yyyy dd/mmm/yyyy mmm/dd/yyyy dd/mm/yy mm/dd/yy dd/mmm/yy mmm/dd/yy

Visual Basic .NET

URGENT Help Required Regarding TIME

by: Striker | last post by:

Hello All I am using asp.net(vbscripts) and sqlserver I am having a problem regarding time comparison, In my application a from field submits datetime in sqlsever database field, now what i need is...

.NET Framework

Issue with triggers, if statement,and count(); its rather urgent.

by: imran haq | last post by:

Hi All, I have 3 rather Long Questions that are causing alot of trouble: I would appreciate all the help i can get and tried to use A post sent to atli in the past but it did not help... !) I...

MySQL Database

Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA