Search results

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

The database is based on candidate contact info - names, addresses and phone numbers (in Barbados). If I upload the DB could you please delete it after analysing it?

Yes. I changed the calculated column to =IIf([TankDate] Is Null,Null,[CountOfSystem]). And the total per record is correct. I named that [TotalTanks] I then tried to get the sum of the [TotalTanks] in the group footer but I keep being prompted to enter parameter value for [TotalTanks] I've...

Thanks. The formulas per record are working just fine and returning the correct results but I can't get a subtotal in the group footer which is very important for this report. I need to show the total number of tanks installed per category.

Actually...looking at the formula *1 does nothing :unsure: I just took it out and the formula per record still works. Just can't get the sum per group to work

I tried entering the above formula but when I run the report the message box "Enter parameter value?" for TankDate pops up and all the results are 0

Hello I have a report showing the dates various activities on a project occurred. We are installing water tanks so I have a date field named TankDate which is the date the tank (or tanks) are installed at a particular property. I also added a field named TotalTanks with the following formula...

Yes, I've used multivalue combos before...they're very useful in instances like this. I made some changes to the report's source query which seems to have fixed that 1 error but I'm still experiencing some glitches. For example I have another report with a button, the code for which names the...

The combo box is a multivalue combo box and some customers are receiving two types of systems - would that make a difference?

Hi. The TankID is the Primary Key and the Bound Column is 1 in the associated combo box in the form