Query Problems

[Keith Ward]

Hi,

I'm building a query which list product via a category selection.

1) I can get access to ask for the category but is there a way to make give
you a drop down box with all the categories in so I don't have to type them
in all the time?

2) I'm also converting prices into euros. So I want to multiply the price by
the conversion factor and then round up. Displaying the euro sign as well?

I have currently FormatCurrency(Round([Price (£)]*1.5,0),0) This is almost
what I want except it puts the £ sign in instead of the € sign, and rounds
normally so that 0.5 rounds up and 0.4 becomes rounds down. I want to always
round up.


Thanks

Keith

 

[Guest]

You can put a combo box on a form, then use the combo to specify the product.
From there have your query use the value in the combo as its criteria.

For the display, add .05 to your calculation before rounding.

As to the Euro sign, that's controlled by the regional settings off your
control panel. The alternative is to look up the character code for the
symbol and use string manipulation to format your result.