Calculated Controls

[David Tro]

Hi,
As a mature student on a distance learning course part of my project is to create a working model for a video hire firm.
What I would like to do is create a form/anything that keeps track of totals eg when videos are hired out, what the cost is to the customer and payment details etc.
I have tried various methods but cant seem to get any joy with them.
Anybody got any help?
Thanks
David

 

[Fizzio]

What methods have you used so far and how is your data structured?
Do you want to show the total cost for this purchase / rent or the entire customers hiring history etc? What costs do you want to total eg Video rent alone or include popcorn, sweets, Haagen Daas ice cream, 'special' under the counter titles etc.

I know it seems a lot to ask but it makes it a bit easier to know what data you are trying to capture.

 

[Newman]

You'll have to be more specific.
What is it that you don't understand?
If you don't know hwo to start at all, may I suggest you take a look at this:
http://officeupdate.microsoft.com/templategallery/
There is a lot of good exemples out there.
Newman

 

[David Tro]

Hello,
All I am after is something that works really, nothing to fancy.
It would just be something that when a customer hires a video, the details of cost etc are placed into a form/table?
It would just contain the customer cost of hiring videos, with a running total for each customer. Also what, in your opinion, would be the best way to go about stock control that is when a customer takes a video out the details of hire are placed into a table then when they return it the video is placed back into the shops inventory.
If any more info is required let me know,
Thanks
David

 

[Fizzio]

Your first job is to get your data structure correct. Identify distinct groups of data that you want to collect and each group essentially forms a table. Some food for thought

tblCustomer
---------------
CustomerID (Autonumber PK)
CustomerSurname
CustomerFirstName
CustomerStreetName
etc...

tblMedia (So you can have Video, DVD, Games, Audio etc)
------------
MediaID
MediaType
MediaIndentifier (May be what you use in the shop)
MediaCategory
MediaPriceCategory
etc....

tblVideoLoans
------------------
LoanID
LoanDate
ReturnDate (may not be neccessary if you have this info in VidPriceCat table)
MediaID
CustomerID

also you could have tables for
Additionals - sweets, popcorn etc

lookup tables
tblMediaTypes
tblMediaCat
tblMediaPriceCategory

etc, etc. How detailed you make it is up to you - Look at the microsoft examples such as Northwind and Solutions - they have some excellent examples - just search microsoft.com for database examples.

Hope this kicks start things.