How Can I do this?

[alex]

I have two questions if anyone can help I would really appreciated.

1. I have a field named “Price†that’s given data like this: $ 35.000000000,
but I want to round the number to only two decimal places so it can look like
this:
$ 35.00. What formula do I need to use to make this work? What would the
correct format be?

2 I have information that’s going up and down (linear) and I want to do a
Crosstab query where different locations have different prices. The locations
would be the column headings, but when I do this and select the “Price†as
the value field I get options to do a min, max, aver, etc but I don’t want
this I want just the actual price without being calculated. How can I do this?

 

[Douglas J. Steele]

1) Set the Format to Currency.

2) If all you have is one price per location, it shouldn't matter whether
you choose Min, Max or Avg: they'll all be the same!

 

[alex]

Thank you Doug but, I can’t change the formatting of the “Price†field
because the data from that field is being supplied by an ODBC table that has
restrictions so I was thinking of doing a formula in the query so I can cut
down all the decimals. Do you know what formula I need to use to achieve this
and what it would look like? On the second question I have several prices for
one location because I have a big list of products which have similar pricing
and I need to be able to see each individual price for each product without
being calculated. Can you help??

 

[Douglas J. Steele]

1) Fields in queries have a Format property. Try simply setting that. The
problem with using the Format function is that it changes the value to a
string, so you can't do arithmetic on it afterwards.

2) I can't envision how you'd use a cross-tab to display multiple values.