Search results

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

I am experiencing some issues with my database and I'm not sure if it's the database or the Access program. One day a combo box or button will work and the next day they won't. Today I updated some customer information and when I went to print the report a field that previously had information...

Yes thank you. Please delete.

I'm going to delete the DB from the forum. I really appreciate everyone's help on this.

Yes! That's what I need to highlight! So it's the order of the expression - [PreInstallationInspectionDate] Is Null As always, thank you so much for your help 😃

That didn't work either :(

Thanks. I couldn't find a shorter description for that field. I will try your suggestion.

I am not familiar with this one. Would I type Len([PreInstallationInspectionDate])>0?

If you use Nz() in your expression, what happens? Not getting the conditional formatting to work with the Nz or with the suggestion of Nz(Dlookup(...),"")

It is a Date/Time field with no default value

Hi, I have a report which is based on a query that includes the following expression named "PreInstallationInspectionDate" (I know it's a long name) DLookUp("[PreInspectionDate]","tblWorkOrder","CandidateID=" & [CandidateID]) In the report, I would like the PreInstallationInspectionDate field...

Thank you for your suggestions. I actually just found the solution myself in the property sheet - I just changed the Separator Characters from "system separator" which by default is a comma, to "New Line" :)