Recent content by JRB

Sorry, my fault. I meant subdatabases. Im still pretty new at Access and the lingo. Any ideas? I have edited the above post so that it is more clear.

Hello everyone, I wanted to know if I can have two subdatabases for a table that are at the same level. More in depth, I have a table of companies. I also have a subdatabases showing all the cash outflows for the company. I would like another subdatabases showing all the the cashinflows...

Thank you so much for your help, cogent. I really appreciate it. Everything worked out...I wasnt aware of that sum button. Have a great day!

Again, cogent1, thenk you for your help. I have followed your advice an created a query, with companies from the ONE table, and amounts from the MANY table. My last question to you all (and sorry if I am being a bother) but once I get to this point, I seem to have trouble sorting by company...

Thank you for your help. However, the problem lies in the fact that when i open up my subdatasheet table, and try to sum amounts, I can only get an aggregate total for all companies. I would like to get an individual total for each company (as each company has 2 or more amounts in it). I am...

Hello Everyone, this is my first time posting here. I am having a problem with subdata sheets (One word or two? Sorry if I got it wrong). I will try to keep his a short as possible. It is similar to the last thread by Rabu5, but extended more. I have a table with many columns for each of my...