Union Query Asking for Parameter Value

  • Thread starter Thread starter stephiesunny
  • Start date Start date
S

stephiesunny

I want the union query to bring in all values.
Both PaymentNet_Spend and PeopleSoft_Spend are queries.

SELECT [PaymentNet_Spend].[Trans ID], [PaymentNet_Spend].[Post Date],
[PaymentNet_Spend].[Trans Amount], [PaymentNet_Spend].[Display Name]
FROM PaymentNet_Spend
UNION ALL SELECT [PeopleSoft_Spend].[Trans ID], [PeopleSoft_Spend].[Post
Date], [PeopleSoft_Spend].[Trans Amount], [PeopleSoft_Spend].[Display Name]
FROM PeopleSoft_Spend;

Please let me know if you have suggestions, thanks!
 
Be sure that both queries:


SELECT [PaymentNet_Spend].[Trans ID], [PaymentNet_Spend].[Post Date],
[PaymentNet_Spend].[Trans Amount], [PaymentNet_Spend].[Display Name]
FROM PaymentNet_Spend


and


SELECT [PeopleSoft_Spend].[Trans ID], [PeopleSoft_Spend].[Post
Date], [PeopleSoft_Spend].[Trans Amount], [PeopleSoft_Spend].[Display Name]
FROM PeopleSoft_Spend


run without asking for that parameter. Paste into a new query, SQL view, to
perform that test.




Vanderghast, Access MVP
 
Back
Top