Issue displaying data in table or form

[issues]

Hi all,

I was not sure which forum to put this under as it kind of covers all of them so i thought best to put it here.

My issue is that i have a database that has alot of different tables forms etc (its for a company i work for) and we use a frontend form to fill in all the data etc, but we have a specific field (Credit Note Value) that will display the figure in the form, but it does not display it in the table. Now the Odd thing is that it displays it upto a certain point (upto June last year) and then it just stops? its is very strange! i have looked at it from all possible angles and tried everything i can think of, can anyone make any suggestions of some things to try please? my level is access knowledge is of an intermediate level so nothing to hardcore and an explination would be appreciated i have attached some pictures to show the different problems of where the value is not showing and where it is showing.

 

[Endre]

Can you supply the pictures as "attachments" rather than an "insert image" so we can all have a look? How are fields in your table defined - that use the data for display? Short Integer? Double? Text? Short Date?
You may have to post the .mdb as there may be underlying queries, code or conditional formating that change your data. Right now at least supply the attachments and we can take it from there...