By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,488 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,488 IT Pros & Developers. It's quick & easy.

Best Way to get "either / or" records from query

P: 2
I have data coming into several tables (from emails leads, contact us forms, phone leads, sales etc). I need to create a report that shows a connection from the sales table back to emails or phone calls. Ultimately, I need to be able to match at least 2 fields (Name-Address, Name-Phone, Name-City, Phone-City) to provide proof to customers that our advertising brought them the sale. What is the best way to attack the problem? It has been awhile since I did alot of Access programming and I may just be having a "brain dead" moment. Not all the sales data will be from my sources, but all the other tables (phone calls, emails, contact us) data will be my data. Do I have to do a series of inner or outter joins? Then somehow join the data in a table? There isn't a way to do more than one join in a single query is there, such as SaleName = PhoneName OR SalesAddress = ContactUsAddress?

Thank you for your help
LindaOSU
Jan 30 '08 #1
Share this Question
Share on Google+
1 Reply


P: 2
I have data coming into several tables (from emails leads, contact us forms, phone leads, sales etc). I need to create a report that shows a connection from the sales table back to emails or phone calls. Ultimately, I need to be able to match at least 2 fields (Name-Address, Name-Phone, Name-City, Phone-City) to provide proof to customers that our advertising brought them the sale. What is the best way to attack the problem? It has been awhile since I did alot of Access programming and I may just be having a "brain dead" moment. Not all the sales data will be from my sources, but all the other tables (phone calls, emails, contact us) data will be my data. Do I have to do a series of inner or outter joins? Then somehow join the data in a table? There isn't a way to do more than one join in a single query is there, such as SaleName = PhoneName OR SalesAddress = ContactUsAddress?

Thank you for your help
LindaOSU

OK, I was brain dead, I realize I have to put OR statements in the SQL.
Jan 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.