Search results

What I'm looking for is not to sum up the numbers in the columns, but there should be only 1 cell that has a numerical value out of the 3 possible for each row.

I completely understand. Thank you for all of your help to this point.

Unfortunately, I cannot upload anything. It is set to Group By because this is what it defaulted to. There are some queries where I need to use Total: Sum so I click the crosstab button and then click back to Select and it keeps it on there and lets me do a Select query. Most of the queries...

Would it just make more sense to do it where each fee has its own query? I know how to do that with the new setup of the database, but this is driving me insane.

Sorry. Missed your post.

Got it. That was painless.

Have to download winzip first.

I'm trying to update my queries, but it is not working properly. I have 3 fees that multiply the total assets by a given percentage. The percentage is in the ClientFees_TBL and is given for each of the fees. Total Assets is located in another query and is easily accessible. There are multiple...

I have another question as to the design of the new database. With the fees they can be dollar amounts, percentages, or Yes/No checkboxes (which are used for some of the queries that are based 100% off of other queries). Would I need to create 3 separate ClientFees_TBL tables to get the desired...

Thank you very much for that explanation. That is something that I had forgotten, but makes perfect sense. I can see where the rows will significantly reduce work down the road and make life much easier. Hopefully the rows based structure will resolve the complexity issue that Access is having...

Ok, but why is that? If you have a group of "things" (such as fees) then you should have them in their own table so you can combine them with another table (clients) that way?

In what way is it not normalized right now? Based off of the knowledge you currently have, I realize you can't see the whole database. I realize that database design is a huge issue and am working on improving my understanding. I am currently taking your suggestions. I have been the whole...

Makes sense. I've been tinkering and found out it has to do with the "cancel" and "reversal" queries. Why they are needed is unimportant. These are set up the same was as the Fee Summary queries (Part 1, Part 2, and Total). However, there are 3 separate ones (1 for each type of revenue) for...

I understand the table structure you are referring to. The problem is I don't understand why the database isn't working the way it is now. I have not reach any known limit on anything that I can see. The only thing I can think of is this: 3 primary queries (Part 1, Part 2, Total). Part 1 +...

No. You're right. You are definitely barking up the correct tree.

That makes sense. Thanks for straightening me out on that one. So it wasn't the amount of memory being used? I don't think it could have been the number of queries, joins, or tables in the specific queries either because they were either under the limit or (in one case) over the limit but...

Oh. I did not know that. That makes sense though. If it were in rows it would have to be set up something like: Fees_TBL: Fee_ID (which is just the name of the fee and I'm not even sure this table would be necessary) Client_Fees_TBL: ClientFees_ID (autonumber or something) Client_ID Fee_ID...

Sorry for my confusion over this. The information is set up in COLUMNS. I considered doing it based off of rows, but was not comfortable with the ways I was coming up with to do it that way. Each client can have any combination of the 35 different fees (anywhere from 1 all the way to 35), but...

Table design: The fees are set up all in the same table. They are in the Clients table. The fees do not have their own table because 1) It would have 2 primary connections between the Recordkeeper (not important info at this time) and the Client tables. Recordkeeper and Client tables are linked...

I've been creating a fairly complex (the equations and calculated fields anyway) Access 2007 database for the company I'm at right now for the past several weeks. I have run into numerous issues and have been able to overcome them all (with help from Access World Forums of course). Here's the...