Specifying the DataType of a new field in a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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.
 
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...
 
Back
Top