VB is it possible to..

[Salochin]

Sorry its me again guys and gals..

Q: is it possible to get VB to filter then also sum: all costs and store that information for later use:

Basics:

My database which im desperatly trying to complete is simple in terms of what I want it to do (its a big calculator) but it needs to calculate many things:

[tblPrinter] 'it has fields' "Printer" , "Tonner", Unit size" , "Cost", "Perprint"

this table has three sorts of printer names each printer has around 7 to 11 components (Tonners etc..) "PerPrint" is how much the printer uses on a print run (dont worry about that calculation for now)

frmPrintCosts has a drop down for me to select which printer im using, once selected via this combo box I need it to filter and total the PerPrint ammount for that printer only then show it in frmPrintCost..

if that made sense to any of you.. as the message on under my name states NEWBIE just want to know if this is possible or should I do this all with qry or Sql

I have around 5 different tbls i need to use and calculate different things and colate it onto the frmPrintCosts so staff can use it to find out how much a print run would be


so frmPrintcosts has

"SelectPrin ter" drop down so im wondering that once selected does the String need the value atached to it (ie veriable or something)
"SelectPape r" drop down
"PagesPerCo py" Val Text box
"CopiesToPr int" Val Text Box
"Total cost per print" (per copy)
"Total cost per print run" (per total Copies to Print)

Sal

thanks in anticipation

[debasisdas]

Yes that is very much possible.

[Salochin]

Hmm thanks anychance you could enlighten me a bit more then YES *grins*

ie do I use declare veribles etc.. not wanting coding as I want to try and write it my self but a head start would be helpfull so I know im heading in the right direction ..

Thanks again for even just a yes it is as at least I know im at least on the right track...


Sal

[debasisdas]

kindly post what you have done so far.

[smartchap]

I think no need to write a sql query for this. These things are possible in simple VB also. Select the required items from Combo Boxes and fill text boxes. Use some formula to calculate the required output. For more specific reply u can post ur code as asked by Mr. Debasis so that we can see what is exactly required by you and how it is possible in a better way.

[Salochin]

I will post code once I have code writen.. thanks for responses