Search results

No, I really need to store this calculated value.

I have a form with 2 subforms. Both subforms include charges (quantity * unit amount). I want to get a grand total of the 2 subforms and store it in the main form’s underlying table. I was going to use SetValue, but can’t seem to get it worded right. I know I shouldn’t be storing a calculated...

I'm getting this message when trying to do an update query: You tried to execute a query that doesn’t include the specified expression ‘tblRental]![PickupDate’ as part of an aggregate function. Can someone suggest what my problem might be?? Thanks

I am doing something similar to what Pat suggested, but am getting an error: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data...

I have several tables (CreditCardTransactions, Rental, WorkOrder, FuelTransaction, Adjustments) that involve transactions. It was suggested that I include an AccountTransaction table to bring all the transactions together, making it easier to do my reports(invoices).

When I enter data in a form, I would like to add some of the info in a second table. What is the best way to do this? The tables have a one-to-one relationship. Thanks, BB

I need to create a report that simply has account names (and numbers) and the total amount charged for the month. Some accounts won't have any charges. (I have an account table.) The major problem is the charges must be calculated from many tables (such as CreditCardStatement, Rental...

Yes, the subreports are based on queries. They include such things as date of service, some sort of ID number, description, unit price, quantity, price*quantity. One of the subreport queries is a little more complicated. This may be my problem? It includes several subqueries, because it again...

I am trying to print invoice reports between certain dates and only for accounts that have charges. The report has account info (from the Account table) at the beginning of each account group, then several subreports each with a different type of charge, and at the end of the account group is...

I have a form with a subform. The user does not enter anything directly into the subform. However, there is a charge on the subform that needs to be included in the total on the main form , but it does not update unless you hit tab or leave the form. How can I handle this? Thanks, BB