Need help with sql select!!

perlfan

Registered User.
Local time
Today, 10:46
Joined
May 26, 2009
Messages
192
Hi! I've spent hours to solve this...please help!

I want to create a report with assigments (payment info etc). listed per translator.
I have a translation table with the fields translator and proofreader. These two fields are linked to ID_Translator in the translator table. The problem is that a translator can appear in the translator and also in the proofreader field of the translation table. But now I need to list all assigments (translation and proofreading assignments) in one report! Is that possible?

Thank you for advice! FRANK
 
If you're asking what I think you are, in a query add the translator table twice. Access will alias the second like Translator_1. Join each of your 2 fields to a different instance of the translator table.
 
Great advice - it still needed a lot of work, but your advice was very helpful.

Thanks- Frank
 
Happy to help. I wouldn't want to do all the work for you. ;)
 

Users who are viewing this thread

Back
Top Bottom