phillsheen
Registered User.
- Local time
- Today, 14:37
- Joined
- Jun 12, 2006
- Messages
- 86
Hi, Ive got another query I need to do which I just dont know where to start from.
I have two tables, membersdata and bankdata. These tables are linked in a relationship thou the field 'description' in both tables.
What I want to do is be able to input a date and have the fields I require from both tables displayed. the dates are stored in the bankdetail table. I have made a query that allows me to input the dates in the bankdata table and that works but I need the membersdata to be shown on this query also.
How can I get the query to show up all the data i requre from both tables?
This query will give me the information of people that have paid us in the dates selected. I also need to revese trhe query so it shows the people who have not paid. so Im basically showing the records with a null value in the description field.
This ones totally caved in my brain this time of the morning! Any help would be fantastic!
Cheers
Phill
I have two tables, membersdata and bankdata. These tables are linked in a relationship thou the field 'description' in both tables.
What I want to do is be able to input a date and have the fields I require from both tables displayed. the dates are stored in the bankdetail table. I have made a query that allows me to input the dates in the bankdata table and that works but I need the membersdata to be shown on this query also.
How can I get the query to show up all the data i requre from both tables?
This query will give me the information of people that have paid us in the dates selected. I also need to revese trhe query so it shows the people who have not paid. so Im basically showing the records with a null value in the description field.
This ones totally caved in my brain this time of the morning! Any help would be fantastic!
Cheers
Phill
