Search results

Nope...which one's that? Though I found another way to do what I want. I just create two crosstabs (one revenue, one membership), then make a table off Membership with extra columns for revenue. Then make a table for revenue (since can't update off the aggregate query), and update the first...

Yep, they do share a single text box, thus causing my difficulty in getting them to format. The membership/revenue heading share a single box on that row as well, and i was wondering if based upon that box I could do formatting. Perhaps there's a way around this? I could create two different...

Month00 Month01 Month02 Month03 Membership 132,428.00 132,428.00 132,428.00 132,428.00 Revenue 1,016,585.00 1,016,585.00 1,016,585.00 1,016,585.00 I attached an example of this too. What I did was make multiple crosstabs, then append them to each...

In the report I have multiple rows of numbers, and sometimes this number represents revenue and sometimes its membership. I have another field on this same row that says "Revenue" or "Membership". Currently i just have it in a general format with 2 decimal places. I'd like the number field to be...

Do you know specifically what the code for this would be? I know VBA with Excel but have very little experience doing it with Access. Thank you for any help. Its still timely.

I dont think IT is going to let me mess with my registry, and method 1 isnt going to always work from the description. As far as I understand it at least. I know VBA for excel, but i'm not very good at it in Access. I guess there isnt a way to say When a file is open, set the odbc timeout = 0...

Is there a way to set it so that every query in a database has the ODBC timout set to 0 instead of 60? Then whenever I create a new query in this database, the setting is already 0, instead of me having to change it from 60 to 0? Thanks.

Cool! Thanks for the help. I'll give these a try.

I have two tables that will have the company name as the joining keys. However, the same company may be entered slightly different (maybe Inc vs Incorporated or such). Is it possible to join these and have Access determine with a 90% certainty or so that they are same thing? THanks.