Jun 14 2011, 05:23 AM
I have a query that looks at one table to work out some criteria (certain text in the field and then is null for the date field), then I want it to pull the address deailts from another table.
Problem is as soon as I add the data from the second form it messes up the query?
Any idea what I am doing wrong?
Jun 14 2011, 07:47 AM
can you post the sql behind the query you are trying to use ?
Jun 14 2011, 08:08 AM
Are you pulling the criteria from forms or from tables?
Also, post the SQL to your query, and let us know what you mean by 'messes up the query'.
Then maybe we will have something to go on to help you.
Jun 16 2011, 02:30 AM
It is a standard Access query, I meant when I use two tables int he query it does not display the information.
This is because my relationships are not setup correctly, I am trying to rectify this now, then hopefully cross table queries will work.
Jun 16 2011, 08:02 AM
OK. Yes, if your relationships are not right, you won't get the data you expect.
Jul 6 2011, 04:17 AM
I had allot more sucess when the relationships were sorted, cheers for the replies
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here