report showing data it shouldnt

[murray83]

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

 

[murray83]

sorry for quick dp but wasn't aware 5 attachments is the max here is the last picture

 

[JHB]

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.

WHERE (((tblChargingTable.ComplianceCode) In (SELECT [ComplianceCode] FROM [tblEmailAddress] )) AND ((tblChargingTable.AppointmentDate)=[For Which Date]));

 

[kevlray]

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.

 

[murray83]

an extra set of eyes

many thanks changed that one thing and bam it worked

cheers