Access Form is becoming selective on fleld data it adds

[andy28348]

I am using the latest version of MS Access and for some reason when I add a new item it either adds partial information to the Table which is linked to a query that goes into my report. I save, refresh constantly and it looks to work when it feels like it. I entered the prices manually so not to get duplicate information this maybe the culprit I am not sure. It is really weird. It works for one report but not this. I can send video and screen shots if need be.

[zmbd]

+ Latest version: Acc2016, Office360, or perhaps Acc2013?

I add a new item it either adds partial information to the Table which is linked to a query that goes into my report.

+ How are you adding the new information?
+ When you run the query does it return your data correctly?
+ Open your query in design view, switch to SQL-View, cut and paste the SQL script.
Please use the [CODE/] formatting tool to format the SQL script.
+ Manually adding the data shouldn't create an issue unless something has gone a-miss in your table design:
Database Normalization and Table Structures