Recent content by Klubby

Ok, I figured out my second query to pull all those other records from the family groupings if they happened to be in the top 50... My problem is now the report. The report is grouped by account manager ascending, and then by A/R amount in descending order. I have NO idea how to incorporate...

thanks! Now, I wonder where should I pull the data? The Top 50 query? A new query based on that query? I cannot seem to get the others listed since they are not in the top 50. Also, where does the subform go on the report? Right in with the detail? Thanks in advance for your help and...

I am using the "Top Values" feature to query and pull our top 50 A/R clients. This is easy and the report based on this report is fine... We have another field in the database that is used that labels client "family groupings." My question is how to pull the rest of the family group in the...

I'm still very stumped on this one..... ugh!

I understand what you mean by that and I believe I have that set-up. My concern is how to capture each month and year in the row/table also based upon user checking the appropriate months in the form. Another example... say we ask for a certain account's statments for each month from Janaury...

:confused: I'm a little stumped on this one. I know there are brilliant folks out here to help, so I thank anyone in advance for some ideas. I am creating a document inventory database for clients engaged in litigation cases. Previsouly, our firm would hold all the information in Excel...

Thank you!! Whew, I'm pretty new to this crosstab query stuff, but finally figured it out. For those newbies out there like me, in the parameter dialog box everyone says needs to be filled in also, remove the "Between" and "And" and all the brackets for EACH field. Essentially, you'll have...

Ok, I actually figured out where the Tools-Parameters are... but what needs to be input there? I tried copying the criteria into the parameter, but received invalid bracketing errors.... I've searched for other posts on this topic and they say these parameters and criteria need to be placed...

I am having this same problem. The crosstab query is based directly on another query, which receives a date range input from a user on a form. The primary query runs just fine, but I get errors when trying to run the crosstab. What do you mean by Tools-Parameters?

I have a Form with a subform. The subform is much wider than the form and is going to be used for data entry. However, when tabbing through the fields on the subform, the screen will not automatically scroll along with the field you are in. Is there a way to have it scroll along with...