Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-16-2019, 11:05 PM   #1
rainbows
Newly Registered User
 
Join Date: Apr 2017
Posts: 100
Thanks: 19
Thanked 0 Times in 0 Posts
rainbows is on a distinguished road
help with quiering costing from multiple options

hi

I have a database called deviation report
i have 3 feilds ( drop down ) boxes called, with at least 10 options to pick from
and one field called cost
1.cause department code
2 problem cosed
3 componet codes


when i complete a form the 4 feilds must be completed

how do i go about getting the sum of the costs from any combination i chose
could be a lot

thanks

steve

rainbows is offline   Reply With Quote
Old 03-16-2019, 11:59 PM   #2
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,678
Thanks: 362
Thanked 216 Times in 190 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: help with quiering costing from multiple options

Judging from the names of your combo boxes (drop down), they do not appear to be numbers. If I have that correctly, summing up the values (a numeric Function) will be quite difficult...
__________________
“I had the RIGHT to remain silent...but I didn’t have the ABILITY.” - Ron White
NauticalGent is offline   Reply With Quote
Old 03-17-2019, 11:28 AM   #3
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 2,032
Thanks: 3
Thanked 441 Times in 434 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: help with quiering costing from multiple options

Assuming the combos are all numeric
Code:
me.txtSum= Nz(Me.combo1) + nz(me.combo2) + .....
NB it would be redundant to save the sum.

Cronk is offline   Reply With Quote
Old 03-18-2019, 04:28 AM   #4
rainbows
Newly Registered User
 
Join Date: Apr 2017
Posts: 100
Thanks: 19
Thanked 0 Times in 0 Posts
rainbows is on a distinguished road
Re: help with quiering costing from multiple options

hi

sorry if I am confusing everyone
the first 3 fields are str fields
for example I could choose in combo one , either . engineering. purchasing , suppliers, assembly
in combo 2 I could choose , operator error, faulty goods, faulty drawings supplier error
the 3 combo box could be . bearings , castings, coolers , fabrications etc

each combo box as at least 20 lines . so there could be over 6000 different records

so if I select assembly, then operator error , then fabrication . to rework that item could cost 500£


this could be for any of the 6000 I can select from


how can I get the costs for each scenario. even when the 3 combo boxes are duplicated


steve
rainbows is offline   Reply With Quote
Old 03-18-2019, 05:02 AM   #5
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,760
Thanks: 67
Thanked 1,935 Times in 1,884 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: help with quiering costing from multiple options

I think it would be more efficient to post a copy of the database with instructions to show the area involved and what you want as output. Your post seems a little light on details and readers(me for sure) seem confused with the real requirement.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Product Costing Query Greyowlsl Queries 5 03-18-2016 05:05 PM
Quoting / costing database NigelShaw General 3 01-29-2011 09:11 AM
Receipes costing chacha General 0 06-30-2009 06:47 AM
Select multiple options from multiple parameters chrisuff Queries 0 06-11-2009 03:00 PM
FIFO Inventory Costing Shep General 5 05-08-2003 11:35 PM




All times are GMT -8. The time now is 12:35 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World