Hi All ,
I build acess database consisted of 5 tables and with the same primary key which is the "Date"
Then , i decided to build a report which gather differnat fields from all this tables and to show it in only one page
My issue , when i preview the report it doesn't show anything other than blank fields .
for that i made some relationaships between the tables and "Date" field was the gate to each table but it doesn't work
Can you please help me ? - i need to know if for example i need to extract some fields from all tables in the date "01.09.10" how to do that ?
Thanks