Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-11-2019, 04:55 AM   #1
murray83
sega collector
 
Join Date: Mar 2017
Location: Daventry, UK
Posts: 444
Thanks: 106
Thanked 1 Time in 1 Post
murray83 is on a distinguished road
report showing data it shouldnt

i have a report which is showing some data correct and then some which it has no need to show based on user input

see attached database and pictures

but simple fact is the user inputs a fault code in this example its 'TL3' then date which is 10/06/19 report runs attaches to email ( may not on ur own pc's )

but then report is showing TL4 can someone much smarter then me tell me why
Attached Images
File Type: jpg click this first.jpg (10.3 KB, 20 views)
File Type: jpg input TL3.jpg (84.6 KB, 20 views)
File Type: jpg input date.jpg (15.3 KB, 20 views)
File Type: jpg attached in email.jpg (60.2 KB, 18 views)
Attached Files
File Type: accdb example.accdb (1.61 MB, 17 views)

murray83 is offline   Reply With Quote
Old 06-11-2019, 04:55 AM   #2
murray83
sega collector
 
Join Date: Mar 2017
Location: Daventry, UK
Posts: 444
Thanks: 106
Thanked 1 Time in 1 Post
murray83 is on a distinguished road
Re: report showing data it shouldnt

sorry for quick dp but wasn't aware 5 attachments is the max here is the last picture
Attached Images
File Type: jpg pdf but why showing TL4.jpg (74.1 KB, 19 views)
murray83 is offline   Reply With Quote
Old 06-11-2019, 05:39 AM   #3
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,082 Times in 2,037 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: report showing data it shouldnt

Do you have a field called "ComplianceCode" in the table "tblEmailAddress"?
I ask because I can't find it and you use it in the below Where clause.
Quote:
WHERE (((tblChargingTable.ComplianceCode) In (SELECT [ComplianceCode] FROM [tblEmailAddress] )) AND ((tblChargingTable.AppointmentDate)=[For Which Date]));

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
murray83 (06-11-2019)
Old 06-11-2019, 05:45 AM   #4
kevlray
Newly Registered User
 
Join Date: Apr 2010
Location: Central California
Posts: 664
Thanks: 9
Thanked 53 Times in 51 Posts
kevlray will become famous soon enough
Re: report showing data it shouldnt

It does not appear that the ComplianceCode is part of the tblEmailAddress table, but there is a SupplierCode. It appears that if you replace the column name (ComplieanceCode with SupplierCode) then the query will work correctly.
kevlray is offline   Reply With Quote
Old 06-11-2019, 05:47 AM   #5
murray83
sega collector
 
Join Date: Mar 2017
Location: Daventry, UK
Posts: 444
Thanks: 106
Thanked 1 Time in 1 Post
murray83 is on a distinguished road
Re: report showing data it shouldnt

an extra set of eyes

many thanks changed that one thing and bam it worked

cheers

murray83 is offline   Reply With Quote
Reply

Tags
report , wrong data

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report not showing data Keefay78 Reports 2 09-01-2017 08:02 AM
Need help with Report showing all data .... Synses Reports 7 03-22-2017 12:41 PM
report not showing sum data redtags2007 Reports 1 09-10-2010 01:00 AM
Report Not Showing Data? louisa Reports 1 05-18-2010 12:11 AM
Data not showing up on report punter Reports 2 02-19-2007 03:57 AM




All times are GMT -8. The time now is 07:56 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World