My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Query From Two Forms, Office 2003
|
|
 Jun 14 2011, 05:23 AM
Post
#1
|
|
|
UtterAccess Veteran Posts: 449 From: UK  |
Hi Guys
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? Graham |
 |
 
|
|
Jun 14 2011, 07:47 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 8,140 From: CT |
can you post the sql behind the query you are trying to use ?
|
|
|
|
|
Jun 14 2011, 08:08 AM
Post
#3
|
|
|
UtterAccess VIP Posts: 2,270 From: Colorful Colorado |
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. - Daryl |
|
|
|
|
Jun 16 2011, 02:30 AM
Post
#4
|
|
|
UtterAccess Veteran Posts: 449 From: UK |
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. Graham |
|
|
|
|
Jun 16 2011, 08:02 AM
Post
#5
|
|
|
UtterAccess VIP Posts: 2,270 From: Colorful Colorado |
OK. Yes, if your relationships are not right, you won't get the data you expect.
Good luck! - Daryl |
|
|
|
|
Jul 6 2011, 04:17 AM
Post
#6
|
|
|
UtterAccess Veteran Posts: 449 From: UK |
I had allot more sucess when the relationships were sorted, cheers for the replies
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 26th May 2013 - 09:55 PM |