relationships and reports in Access 2000

[retro]

I am having a problem with my label report for my database.

I have a table called Labels. This contains the following fields:

LabelID (primary key)
CategoryID (lookup from table: Categories)
Length (text)
Price (currency)

The lookup is for the field: Category in the Categories table.

I have 2 problems:

1. The Price field is fine in table view, e.g. type in 3.30 and it displays £3.30. However, on the report it displays 3.3

2. The Category entry =Trim("Category: " & [CategoryID]) displays the number associated in the Labels table, NOT the text value assigned in the Categories table.

How do I get the currency to display correctly, e.g. always with two digits after the decimal point? Also, how do I get the text value to show in the Category field?

Many thanks in advance for any assistance.

 

[fuzzygeek]

Need to check a few things

In the design mode for the report select the Price field. Do a left click and properties. Choose the format tab. Under decimal places, select 2 instead of Auto.

Go back to your table and look up LOOKUP. Check the SQL statement to insure that you have two, the first should be the Catid and the second the Category. Then look at the bound column which should be 1. Lastly check the column count (2) and the column Widths. It should have a zero first and a value secondly ex. 0";2.2917".