Specifying the DataType of a new field in a Query

D

Dodsey77

Hello,

I have been given some help from users on here to do with finding the
highest value from 3 different fields, and have got it to work using the
MaxOfList function within a query.

So, I have the following in the field section of a query:

MaxPrice: MaxOfList([LowPriceRange],[HighPriceRange],[Price])

What I would like to know, is how I can specify that I would like MaxPrice
to be of the DataType "Currency".

Does anyone know how you specify this?

Thanks in Advance,
 
K

KARL DEWEY

Open the query in design view, click at the top of the grid column of the
field and highlight it. Right click and view properties. Set the format.
 
D

Dodsey77

That's excellent! I thought it might be something simple!

Brilliant, thanks!

KARL DEWEY said:
Open the query in design view, click at the top of the grid column of the
field and highlight it. Right click and view properties. Set the format.

Dodsey77 said:
Hello,

I have been given some help from users on here to do with finding the
highest value from 3 different fields, and have got it to work using the
MaxOfList function within a query.

So, I have the following in the field section of a query:

MaxPrice: MaxOfList([LowPriceRange],[HighPriceRange],[Price])

What I would like to know, is how I can specify that I would like MaxPrice
to be of the DataType "Currency".

Does anyone know how you specify this?

Thanks in Advance,
Click to expand...
Click to expand...
 
Top