Problem In Unmatched Quire IN MSAccess

%3CLINGO-SUB%20id%3D%22lingo-sub-1303726%22%20slang%3D%22en-US%22%3EProblem%20In%20Unmatched%20Quire%20IN%20MSAccess%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1303726%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%20class%3D%22_2cuy%20_509y%20_2vxa%22%3EIF%20sources%20data%20is%20changed%20by%20query%20design%20(by%20concatenate)%20and%20then%20this%20quire%20is%20use%20for%20unmatched%20quire%20wizard%26nbsp%3B%20in%20that%20case%20no%20result%20showing.%20But%20if%20maintain%20original%20data%20and%20use%20unmatched%20quire%20then%20showing%20result.%20What%20is%20the%20reason%20of%20it.%20Can%20any%20one%20ple%20help....%3C%2FP%3E%3CP%20class%3D%22_2cuy%20_509y%20_2vxa%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_2cuy%20_509y%20_2vxa%22%3EI%20have%20attached%20the%20file%20for%20batter%20understanding.%3C%2FP%3E%3CP%20class%3D%22_2cuy%20_509y%20_2vxa%22%3EBoth%20in%20NPS%20ATM%20and%20NPS%20ATM%20REV%20quire%20i%20use%26nbsp%3B%3CU%3E%3CSTRONG%3EJOIN%3A%20%5BRRN%5D%20%26amp%3B%20%22%20-%22%20%26amp%3B%20%5Bterminal%20ID%5D.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FU%3EAnd%20then%20join%20column%20outcome%20is%20used%20for%20Unmatched%20quire%20wizard%20but%20didn't%20showing%20and%20result.%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22_2cuy%20_509y%20_2vxa%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1303726%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hello,

IF sources data is changed by query design (by concatenate) and then this quire is use for unmatched quire wizard  in that case no result showing. But if maintain original data and use unmatched quire then showing result. What is the reason of it. Can any one ple help....

 

I have attached the file for batter understanding.

Both in NPS ATM and NPS ATM REV quire i use JOIN: [RRN] & " -" & [terminal ID]. And then join column outcome is used for Unmatched quire wizard but didn't showing and result. 

 

0 Replies