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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert datatype using query 7
Can a query field display as datatype hyperlink? 1
Datatype on Queries 4
grouping query 2
where do I set the datatype for a field 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Delete Query: Could not delete from specified tables 0
"Query must use updateable query" error message 2

Back
Top