Search results

I generated a report with simple calculated controls from a query that select 3 records. In the report I simply summed the columns from the query. The problem is that the totals appear 3 times, one for each query record when I only need it to show up once. Any ideas to fix this? Thank you...

Hello: I generated a report with simple calculated controls from a query that select 3 records. In the report I simply summed the columns from the query. The problem is that the totals appear 3 times, one for each query record when I only need it to show up once. Any ideas to fix this...

Hello: In an update query I have the following: (([total meal expense])/([total expenses]))*100 However, this returns 6800.00% in my table. If I delete the *100, I get 100.00% - doesn't make much sense. In my table I have the Meal Expense% field as a number/percentage. Any idea on the...

Hello: I created a simple SQL macro to update fields in my database, however, once I run the macro, access prompts me to enter paramater values, how do I get rid of the prompts or why are they occuring?

I am trying to write simple code in visual basic for a module to add the contents of two fields in my table and update the result in another field in the table (macro and sql stuff too lengthy). I am novice, what is the syntax? Table name = Main Table field names = Expense1 and Expense2...

I put an expression in the controlsource property and I want that value to show up in the underlying database in the appropriate field. I can't believe it is not set up to do so automatically. Any recommendations, or do I have to write code? O.K., let's see, I created a form based on the...