Specifying the DataType of a new field in a Query

[Guest]

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,

 

[Guest]

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.

 

[Guest]

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

Brilliant, thanks!

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.

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,