Search results

Perfect!! Thank you!! :D

Hi guys, My issue is this: My form consists of a bunch of text boxes that calculate off of one text box (only one you can edit) at the top of the form. My problem is, whenever I enter this form, it will attempt to calculate all the fields (which takes a good deal of time) when there is nothing...

I was playing around with it and got it to work! =DCount("[E-Mail]","Detail","[E-Mail] Not In (Null, '')" & " AND [Primary] = [Products]![Product Code]")

Is it not? I'm not sure how else to tell a DCount formula to not include blank cells. Edit: I'm still somewhat a newbie.

Hey guys. I think I read somewhere that DCount will not count blank cells, but when I try to do it - it counts everything. Here is my formula: =DCount("[E-Mail]","Detail","Not IsNull([E-Mail])" & " AND [Primary] = [Products]![Product Code]") Basically, I want to count the number of email...

Working now! Thanks pbaldy! Formula is: =DCount("[Asgn Type]","Detail","[Asgn Type]='SG'" & " AND [Primary] = [Products]![Product Code]")

I'm trying to get the count of how many lines SG shows up in with the Primary on that line matching the Product Code. And that formula gives me the #Name? error now. I guess thats better than the #Error? lol

Hey guys, I looked through all the previous posts about this, but it seems that I can't get my formula to work. I keep getting the dreaded #Error message on my form. What I'm trying to do: I'm trying to get the count of all lines that have 'SG' in the Assgn Type column from the Details table...