I want to create a label report based on a query.
The database has two tables: Categories and Labels. Categories is used to list (surprise surprise) categories, and is used as a lookup in Labels.
I accidentally created a normal report, and everything came out fine! The categories came out correctly, as did the price (a currency field).
However, when I create a label report the following happens:
1. Instead of displaying the category correctly, it displays the CategoryID number.
2. Whenever there's a price ending in a 0, e.g. £2.10 it cuts the 0 off, e.g. £2.1
BOTH this errors ONLY happen in label report - as a normal report they come out fine!
What can I do? I tried what was suggested before on the forum, to no avail. I'm guessing this is because I didn't mention it was a label report!
Many thanks in advance.
The database has two tables: Categories and Labels. Categories is used to list (surprise surprise) categories, and is used as a lookup in Labels.
I accidentally created a normal report, and everything came out fine! The categories came out correctly, as did the price (a currency field).
However, when I create a label report the following happens:
1. Instead of displaying the category correctly, it displays the CategoryID number.
2. Whenever there's a price ending in a 0, e.g. £2.10 it cuts the 0 off, e.g. £2.1
BOTH this errors ONLY happen in label report - as a normal report they come out fine!
What can I do? I tried what was suggested before on the forum, to no avail. I'm guessing this is because I didn't mention it was a label report!
Many thanks in advance.
