data not entered through data entry form does not display in query or report

Rahul2310

New Member
Joined
Oct 19, 2013
Messages
2
I am new to access 2010
I have created tabels and forms to enter data in tabel
when i import data through excel it does not show in reports
The reports are generated through query criteria
 
Last edited:

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
I surely don't know anything about access (accept for using it like a dummy-user. But this typical problem sounds like a formatting problem. If the criteria is a number, and numbers as text or formulas are imported you can get these kind of problems.

sometimes you'll have to think outside of the box. Why don't you export the data again from access to excel. You'll than have a total overview for all entries and can compare the formatting. Succes!
 
Upvote 0
I surely don't know anything about access (accept for using it like a dummy-user. But this typical problem sounds like a formatting problem. If the criteria is a number, and numbers as text or formulas are imported you can get these kind of problems.

sometimes you'll have to think outside of the box. Why don't you export the data again from access to excel. You'll than have a total overview for all entries and can compare the formatting. Succes!

thanks dutch for ur reply problem is solved, reinstalling access did it for me
 
Upvote 0

Forum statistics

Threads
1,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top