Programming Help

Web Development



What's Here?

  • Members: 137,384
  • Replies: 481,893
  • Topics: 75,127
  • Snippets: 2,568
  • Tutorials: 676
  • Total Online: 2,119
  • Members: 63
  • Guests: 2,056

Welcome to Dream.In.Code
Become an Expert!

Join 137,384 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,119 people online right now. Registration is fast and FREE... Join Now!




Access - Calculating Profit

 
 Reply to this topicStart new topic

Access - Calculating Profit
firefighter17103
11 Oct, 2008 - 08:26 AM
Post #1

New D.I.C Head
*

Joined: 11 Oct, 2008
Posts: 3


My Contributions
Hi to all,

I am fairly new to access and I am working on making a database for a new business adventure. I already made my Product Listing Table and I want to take what I sell the unit for and subtract my cost so it will give me my profit. I am going to have a total of 5 different tables that I need to do this to. I would like for it to show in a report and on a form as well in the table. I really appreciate any help that anyone can provide. If any more information is needed or if some one wants to see my data base just let me know. Thanks again in advance for all your help.

Here is what my table looks like

Camera Products
Product ID(Primary Key
Manufacturer(Lookup List from another table)
Distributor(Lookup List from another table)
CCD
Lens
IR
MinLux(Color)
MinLux(B/W)
Resolution
OpticalZoom
DigitalZoom
Style(Lookup List)
Control
AutoIris(YES/NO Checkbox)
Day/Night(YES/NO Checkbox)
Outdoor(YES/NO Checkbox)
Heater(YES/NO Checkbox)
Fan(YES/NO Checkbox)
VandalProof(YES/NO Checkbox)
AddtionalInfo
Cost
MSRP
OurPrice
Profit(This is what I would like to accomplish)



This post has been edited by firefighter17103: 11 Oct, 2008 - 08:59 AM
User is offlineProfile CardPM
+Quote Post

dlkirk03
RE: Access - Calculating Profit
13 Oct, 2008 - 05:54 PM
Post #2

New D.I.C Head
*

Joined: 12 Sep, 2008
Posts: 24


My Contributions
After you update the sell price or the cost which ever comes last in the form go to the after update and build the vb code where me. Profit = me. Sell - me. Cost. Set the profit field to invisible so it is not seen but is updated. You need to add some if statements that will check to see if the other field has any information in it. You could put the code on both fields so that if the record is updated it will still make the calculation. But this won’t give you your profit unless you actually put in the quantity. And multiply the result of (sell - cost). Hope this helps.
User is offlineProfile CardPM
+Quote Post

PsychoCoder
RE: Access - Calculating Profit
13 Oct, 2008 - 06:20 PM
Post #3

using DIC.Core;
Group Icon

Joined: 26 Jul, 2007
Posts: 9,009



Thanked: 126 times
Dream Kudos: 8625
Expert In: VB, VB.Net, C#, SQL, ASP, ASP.Net, Web Development, HTML, CSS, Win32 API, Javascript, mySQL, J#, Boo.Net

My Contributions
Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Please post like this:

Thank you for helping us helping you.
User is offlineProfile CardPM
+Quote Post

firefighter17103
RE: Access - Calculating Profit
13 Oct, 2008 - 08:12 PM
Post #4

New D.I.C Head
*

Joined: 11 Oct, 2008
Posts: 3


My Contributions
I don't know VB or code. I really just want to make a simple database to track customers, products and orders. I ran a query and was able to get it to calculate the profit. I was also wondering ho to have it show in the form that I am making to add/view products.

This post has been edited by firefighter17103: 13 Oct, 2008 - 08:15 PM
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/5/08 02:02AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month