Field not showing values

[fleurette]

Hi
I had created a report format.

However, the data is now showing on the generated invoice.
The rest are showing up but one.

I went back to the tables to check and there is data present.
It used to work until recently.

Seems like somethings in access are intermittent?


Can anyone tell me what I am doing wrong?

Thanks

 

[pr2-eugin]

fleurette, your description is vague.. Could you give another shot in explaing the problem?? How are you getting the Reports? A Form filtered Query? Or a simple straight forward Query? What do you mean

The rest are showing up but one.

 

[fleurette]

fleurette, your description is vague.. Could you give another shot in explaing the problem?? How are you getting the Reports? A Form filtered Query? Or a simple straight forward Query? What do you mean

Sorry I wasn't clear.
I used a report wizard to add the fields I want for the invoice.
They are fields from 2 tables.

So I have customer name, address, order number and invoice number and some other details.

Everything is showing up but my invoice number.

It used to show up but now it's just blank.

 

[pr2-eugin]

Check the RecordSource of the Report.. See if the two tables have a Join between them.. IF they do not, try adding the JOIN between the two.. You should be sorted..