Been using the access database created by a previous employee for a year without any issues. All of the sudden, the data I am entering in the table is not showing up in the query or report. Any suggestions on how to fix it?
Novice
Windows 7 64bit 
Access 2010 64bit
Table Info Not Connecting to Query or Report
Been using the access database created by a previous employee for a year without any issues. All of the sudden, the data I am entering in the table is not showing up in the query or report. Any suggestions on how to fix it?
Access Developer
Windows 7 32bit Access 2003
IMHO You should not be entering data directly into tables. would be better to use a form.
Is the data actually being saved in the table.
What happens when you view the query. Do you see any records at all.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
VIP
Windows 7 64bit Access 2010 32bit
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 64bit Access 2010 64bit
I stand corrected. I am entering the info into the form. However it is not then showing up in my query or report.
Originally Posted by sarabeth
Moderator
Windows XP Access 2003
I recommend you take up June7's offer.
Connecting Forms to a Report
Query displays info in Datasheet view - not desired Report
Posting Permissions
Reply With Quote