From: sheri on 8 Oct 2009 16:54 The results are that every check is matched with every deposit. Does that help. I tried changing the Join to left in the SQL view and it said it wasn't supported. "sheri" wrote: > Okay, so I'm using Access 2000 and I'm not a programer so please speak in > plain english. I have a table of all donations made and a table of all > checks cut out of our program. The relationship between the tables is an ID > if applicable and in some cases a donation key. Some, but not all, donations > are related to checks and visa-versa and not all donations or checks have an > ID. I'm trying to run a report by ID that shows both the donations and > checks. I've designed a simple query to pull the information together but > the results are showing a lot of duplicate records and I'm not sure why. > > Thanks in advance!
From: Klatuu on 8 Oct 2009 17:19 That helps some. In the query builder, there should be a line between the main table and the other tables. If you right click on the line to get a dialog that shows the join type, try choosing the option to show all the records in the main table and only matching record is the other tables. This will not give you exactly what you want, but if we can get that far, we can work it from there. -- Dave Hargis, Microsoft Access MVP "sheri" wrote: > The results are that every check is matched with every deposit. Does that > help. I tried changing the Join to left in the SQL view and it said it > wasn't supported. > > "sheri" wrote: > > > Okay, so I'm using Access 2000 and I'm not a programer so please speak in > > plain english. I have a table of all donations made and a table of all > > checks cut out of our program. The relationship between the tables is an ID > > if applicable and in some cases a donation key. Some, but not all, donations > > are related to checks and visa-versa and not all donations or checks have an > > ID. I'm trying to run a report by ID that shows both the donations and > > checks. I've designed a simple query to pull the information together but > > the results are showing a lot of duplicate records and I'm not sure why. > > > > Thanks in advance!
From: sheri on 8 Oct 2009 17:40 I don't have a "main table" per se. I tried changing one of the joins and now it's saying "The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement. (Error 3258)" So, I'll try doing that. "Klatuu" wrote: > That helps some. > In the query builder, there should be a line between the main table and the > other tables. If you right click on the line to get a dialog that shows the > join type, try choosing the option to show all the records in the main table > and only matching record is the other tables. This will not give you exactly > what you want, but if we can get that far, we can work it from there. > -- > Dave Hargis, Microsoft Access MVP > > > "sheri" wrote: > > > The results are that every check is matched with every deposit. Does that > > help. I tried changing the Join to left in the SQL view and it said it > > wasn't supported. > > > > "sheri" wrote: > > > > > Okay, so I'm using Access 2000 and I'm not a programer so please speak in > > > plain english. I have a table of all donations made and a table of all > > > checks cut out of our program. The relationship between the tables is an ID > > > if applicable and in some cases a donation key. Some, but not all, donations > > > are related to checks and visa-versa and not all donations or checks have an > > > ID. I'm trying to run a report by ID that shows both the donations and > > > checks. I've designed a simple query to pull the information together but > > > the results are showing a lot of duplicate records and I'm not sure why. > > > > > > Thanks in advance!
From: Klatuu on 8 Oct 2009 17:48 Unless I am mistaken, in this case, Expenses SPA DEV would be your main table. -- Dave Hargis, Microsoft Access MVP "sheri" wrote: > I don't have a "main table" per se. I tried changing one of the joins and > now it's saying "The SQL statement could not be executed because it contains > ambiguous outer joins. To force one of the joins to be performed first, > create a separate query that performs the first join and then include that > query in your SQL statement. (Error 3258)" So, I'll try doing that. > > "Klatuu" wrote: > > > That helps some. > > In the query builder, there should be a line between the main table and the > > other tables. If you right click on the line to get a dialog that shows the > > join type, try choosing the option to show all the records in the main table > > and only matching record is the other tables. This will not give you exactly > > what you want, but if we can get that far, we can work it from there. > > -- > > Dave Hargis, Microsoft Access MVP > > > > > > "sheri" wrote: > > > > > The results are that every check is matched with every deposit. Does that > > > help. I tried changing the Join to left in the SQL view and it said it > > > wasn't supported. > > > > > > "sheri" wrote: > > > > > > > Okay, so I'm using Access 2000 and I'm not a programer so please speak in > > > > plain english. I have a table of all donations made and a table of all > > > > checks cut out of our program. The relationship between the tables is an ID > > > > if applicable and in some cases a donation key. Some, but not all, donations > > > > are related to checks and visa-versa and not all donations or checks have an > > > > ID. I'm trying to run a report by ID that shows both the donations and > > > > checks. I've designed a simple query to pull the information together but > > > > the results are showing a lot of duplicate records and I'm not sure why. > > > > > > > > Thanks in advance!
From: sheri on 8 Oct 2009 17:54 Okay so I wrote a query to identify all allocated donations (ones with an ID) and then I wrote another query using that query and adding the expenses table but it still gives me multiple records no matter how the join is performed. "Klatuu" wrote: > That helps some. > In the query builder, there should be a line between the main table and the > other tables. If you right click on the line to get a dialog that shows the > join type, try choosing the option to show all the records in the main table > and only matching record is the other tables. This will not give you exactly > what you want, but if we can get that far, we can work it from there. > -- > Dave Hargis, Microsoft Access MVP > > > "sheri" wrote: > > > The results are that every check is matched with every deposit. Does that > > help. I tried changing the Join to left in the SQL view and it said it > > wasn't supported. > > > > "sheri" wrote: > > > > > Okay, so I'm using Access 2000 and I'm not a programer so please speak in > > > plain english. I have a table of all donations made and a table of all > > > checks cut out of our program. The relationship between the tables is an ID > > > if applicable and in some cases a donation key. Some, but not all, donations > > > are related to checks and visa-versa and not all donations or checks have an > > > ID. I'm trying to run a report by ID that shows both the donations and > > > checks. I've designed a simple query to pull the information together but > > > the results are showing a lot of duplicate records and I'm not sure why. > > > > > > Thanks in advance!
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 5 Prev: Please Help?? Split Database - Refering to backend Next: 89 Opinion Dsiconsolas.com |