Search results

I have a report with 4 subreports. Each grouping of subreports gives me a total and I have multiple groupings in the report. I want a detailed summary of all these group totals. E.g. Group A Total = $1000 Group B Total = $1500 Each subreport is based on a query and each query has a total. For...

Hi! I have created a report with 4 subreports located in the detail section of the mainform. Each subreport has a sum in the report footer. These sums are working. On the mainform detail section, I added a textbox which adds the sums from the 4 subreports. After the first grouping, the sum shows...

I have 5 tables and want the value from one table to be transferred to another, based on certain criteria. Basically, I have tblProjectEC, where rates for a particular project are stored. Then I have tblECReport, where details concerning actual expenses for a particular project are stored. My...

I have a query that pulls information from three tables: tblEquipConsCode (table basically lists types of equipment - e.g. sampling supplies) ECPK ECCodeDescription ECDefaultUnit tblProjectEquipCons (table captures the project specific equipment and rates) PECPK ProjectFK (ties into my Project...

Hi - I am trying to create a timesheet and invoicing database. Projects will be identified and then employees will enter their time and expenses, which will be associated with these projects. An invoice will then be created and will draw all the time and expenses based on a certain timeframe...

I have a parameter form where the user chooses a site name. Once the name is selected and the user hits the OKAY button, the form closes and I've set up macros to run a query and a report based on the selection. The first time I go through this, all works perfectly. Now, when I want to run a...

Hi! I am pretty new to Access and am starting a new database - I'm just planning it out now. One of my tables will store information on technical reports (e.g. report name, file number, author and report date). Some of the reports are dated with day/month/year, but some only state month/year. So...

Hi all! I'm fairly new to Access. I have been working on a database for a few months and am always looking to make improvements to it. While I have learned a lot about Access in the last while, there is so much more to learn...