What is Infinity called.....

[soupisgood84]

Just a quick question that I couldn't Google; (evidently there is something called VBA Infinity, lol)

I am setting perimeters for a query and I would like to know how to set a -Infinity and +Infinity to a price.

Please help...thanks

Me!txtLowerPrice = -Infinity
Me!txtUpperPrice = Infinity

 

[SkipVought]

Hi soupisgood84,

Are you sure that your computer has enough internal memory? After all, infinity is a pretty big number, you know!

Seriously though, NaN, Infinity, and Divide by Zero are new VB.NET constants. Nothing here in VBA.

Skip,

_[red][/red]

 

[PHV]

Use a Null value for your form parameters and have criteria like this in your query:
WHERE ([price field]>=[Forms]![form name]![txtLowerPrice] OR [Forms]![form name]![txtLowerPrice] Is Null)
AND ([price field]<=[Forms]![form name]![txtUpperPrice] OR [Forms]![form name]![txtUpperPrice] Is Null)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Crowley16]

erm, why not just leave the perimeters out?

--------------------
Procrastinate Now!