Adding 2 different Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have fieldx in tble1 and fieldy in tble2 I would like to add them up by row
ie. and put that information in tble3
the thing is that if tble2 does not have a matching record,but tble1 has
something then report returns nothing!

Sum([tble1].fieldx +[tble2].fieldy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding hours past 24 2
Like clause, 2501 records and a major headache... 2
HELP! cannot pick from combo box 4
Union query dropping duplicates 2
Combo Box Display Missing After Office 2003 Service Pack 3 16
Strange behavior on query - Help?? 5
Windows XP weird problem with dates in query! 0
Records split into two rows 5

Back
Top