Search results

This is my intro to programming and the programmer at work who has been graciously helping me is on vacation. I am trying to program a subform to automatically set certain fields based on the criteria in the main form or earlier records of the subform. I made the changes my programming friend...

have an Escalation database which has a subform which contains a series of price adjustments. The first price adjustment is based on the initial rate in the main form but I need to program the form so it calculates on the 'current rate' from the latest record in the subform. I have tried to...

I have a subreport/subquery that is based on a query that asks the user to input either 1999 or 2000. When I try to run the report, the parameter query repeats three times. Can I get the subquery to "get" the year from the main query?

I have a Contract Type column in my monthly report. I need to have a listing of all values returned in this column and a count of how many. How can this be done? eg. May PM Contracts: 5 TM Contracts: 2 June AG Contracts: 7 PM Contracts: 12

I have a RecordCount that totals each record in my detail, but I want to have one total in my 'Group by'Branch footer, and one 'subtotal' in my 'Group by' Industry footer. I can only get Access to display the subtotal from the last Industry in a Branch as the Branch Total. If I only try to...

I need to create a report based on up to 5 queries and have the results show in an executive summary page (with totals by section) and then list all the detail after. Would it be best to create seperate queries for each section and then one Very Big query for the report, or is there another...