PDA

View Full Version : Reports Issue



mfaisal.ce
01-01-2021, 06:39 AM
Hello,

I want to make a report based on 2 tables which are not joined together by relationship... what is the way because when i try to make report, error comes that there is no relationship between tables.... Actually, i wan to make a report based on daily expense & sale tables..... kindly guide..

OBP
01-03-2021, 05:26 AM
The simplest way is to create a query, they are the powerhouse of Access (besides VBA).
You can create the relationship in the query.
But I have to ask the question, why isn't there a relationship between your tables, as relationships are the basis of Access.

Gasman
01-03-2021, 02:51 PM
Crossposted with replies https://www.access-programmers.co.uk/forums/threads/report-issue.315498/#post-1739764