Round in a query

[TomSwingruber]

Access 2000 and VB6

line from query {

round(Price_ft/12),2)) * Length ) + Short_cut_price as [Each], "

}
returns unkowen function round

 

[AndyWatt]

And the rest of the expression says what? A quick count shows four closing brackets and one open. What is "Length"?

Andy
"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux
"A computer program does what you tell it to do, not what you want it to do." -- Greer's Third Law

 

[Diederik]

Round(Price_ft/12, 2) might help?
And I'm with Andy, count them bracket pairs...

Diederik

 

[TomSwingruber]

I know the brackets a goffy sorry.
the question really is
How do you use the round function in a query.
thanks for any help
tom

 

[CCLINT]

You need the right versions of the VBAJet.Dll and expsrv.dll.

So, start by updating JET to the latest SP for your OS:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q239114

It's not so much that the VBA functions were or weren't available in other versions, but that you have different versions of the JET Dlls which are not completely compatible with one another.

You will need to inpect and compare all versions of all JET dlls on your system if the service pack doesn't help.

 

[TomSwingruber]

I updated my dlls still could not get the round function to work from a query.
I had to forge on so used a crude work around that gets the job done without the round function.

If I insert the query directly into access it work fine.
But invoking from VB6 fails.
Maybe its me or its B Gates. oh well

Thank you for helping.
Tom