Search results

A different issue has arisen. There are 4 sizes of water tanks but only 2 sizes were delivered in January. When I try running the report I am getting an error message stating that the access database does not recognize the [tank size] as a valid field name or expression. Is there a way for a...

Thank you! I made the changes but was still getting the #Name? error message. However, I ran a basic query (not a cross tab query) and used that as the domain and the forumla with your recommended changes worked. thanks again!

Hello, I have a report that is based on a crosstab query which shows the deliveries of water tanks by year and month. The row headings are year and month, column headings are the different size water tanks and the value is the qty received. For this new year, I would like the 2022 deliveries...

Yes...you are correct. For every 1000-gal system, two 1000-gal tanks are installed. I too queried why it wasn't referred to as a 2000-gal system but that is how the contract was issued so I have to use those references in my DB. So when I was asked this week to confirm the number of tanks...

Thank you for your input but we have 182# 1000-gal SYSTEMS to install. Each 1000-gal system will consist of 2x1000-gal tanks. There are no 500-gal tanks. The tally is per system as each system will include tanks as well as pumps, plumbing and electrical fittings, etc. However, with regards...

Thank you again for your help! This is counting the tanks per system as I needed. I can now use this for the next week's reports.

Thank you. I will try and let you know if it works. I was able to send off the other reports this morning thanks to your great assistance. I used excel to create the report with the actual sum of the tanks but I will try your suggestion so next time I can run it in Access

Hi again. I need help with one more thing. Where ever we have to install a 1000-gal system, the candidate is receiving 2# tanks per 1000-gal system. I'd like the DCount formula to include a criteria that would look for "*1000-gal*" and multiply by 2 so I can get the actual number of tanks...

I can't thank you enough for your help on this. I changed the source query as you outlined above, removing all the Dlookup formulas. Then in the group footer I added the formulas =Sum(IIf([BaseInstallationDate] Is Null,Null,[CountOfSystems])) and =Sum(IIf([TankInstallationDate] Is...

Hi Only 1 work order is generated per candidate and is only generated once the pre-installation inspection is done. If I were to include the tblWorkOrder in this particular report, the report would exclude all those who have not been inspected yet. I need to show all candidates so that we can...

The group summary is for my boss' reference so he can quickly see totals per group and per parish

This might not be possible. The problem I am getting is that a work order is only generated when a property is inspected prior to installation. In the WorkOrder table I have all the date fields that I need for this particular report. However, if I run a WorkOrder report it is not showing...

The TotalTanks textbox is in the report only. It is not on any form or in the source query. Due to the info I need to show in this report there are quite a few Dlookup fields to get the activity dates.

No no...different names. I haven't even named the calculated field in the group footer - still the generic TextNo In the details section I have highlighted the [TotalBases] and [TotalTanks] which are what I need to sum in the group footer

Ok...that will be 9pm over here so I will wait for your help as I really want to get this report completed tonight. thank you so much

Prompt to enter paramater value for TankDate pops up again

I am going to upload the DB...maybe fresh eyes can see something I am missing. But I will need to delete it as soon as possible

It is working in the details section

No error message or prompt asking for parameter value but the result is blank