What's wrong with this expression?

[jeffmoseler]

This is what I have:

=DCount("[Printed]![PartNumber] ","Printed","Printed!PartNumber= [ItemOnlyFormTex2] And Printed!SalesOrder = [SalesOrderNumFormTex2] ")

It isn't working and I'm not sure why. I know it's a syntax thing, and I know it has to do with the AND, but I don't know what I am doing wrong. What suggestions do you have?

 

[Andrew Fergus]

Hi Jeff

I haven't test this but try this:

=DCount("[PartNumber]","Printed","[PartNumber] = '" & [ItemOnlyFormTex2] & "' And [SalesOrder] = '" & [SalesOrderNumFormTex2] & "'")

If 'ItemOnlyFormTex2' exists on a form, then you may need to set it up like this instead:
Forms![YourFormName].[ItemOnlyFormTex2]

Repeat for the 'SalesOrderNumFormTex2' part.

HTH, Andrew

 

[jeffmoseler]

Thanks Andrew,
It is still not working even after I ended up with this:

=DCount("[PartNumber]","Printed","Table!Printed![PartNumber] = '" & Forms!PrintTravelerForm.ItemOnlyFormTex2 & "' And Tabel!Printed![SalesOrder] = '" & Forms!PrintTravelerForm.SalesOrderNumFormTex2 & "'")


Here's a hint:

=DCount("[Printed]![PartNumber] ","Printed","Printed!PartNumber= [ItemOnlyFormTex2]")

The above works fine. It counts all the records that match the PrintedPartNumber to the control on the form. But when I add the AND it shows an error. I can tell you that both the SalesOrderNumFormTex2 and the ItemOnlyFormTex2 are controls on the form. I can also tell you the fields in the table are both formatted as text.

Thanks so much for the help Andrew!

 

[Marbles]

I've tried this with a table, and it seems to work:

=DCount(" [ENGINE_TYP]","Boats"," [ENGINE_TYP]='OU'")+DCount(" [ENGINE_TYP]","Boats"," [ENGINE_TYP]='Pe'")

Would that help?

 

[Marbles]

No it wouldn't, sorry.

 

[Marbles]

This one instead:

=DCount(" [ENGINE_TYP]","Boats"," [ENGINE_TYP]='OU' And [No_Berths]=2")

 

[Andrew Fergus]

Hi Jeff

The format of the two fields on the form - are they text or numbers?

Andrew

 

[jeffmoseler]

DOh... I figured it out. One of my controls had bad syntax, but I couldn't see it because it was hidden! Thanks guys!