bug check, must be blind

[Thales750]

hey guys

would someone check this please

This works:

LOCCONCurent = DCount("ContactID", "tblContactLocation", "tblContactLocation.ContactID=[Forms]![frmContactNew]![ContactID]")

This apperently does not:

LOCCONCurent = DCount("ContactID", "tblContactLocation", "tblContactLocation.ContactID=[Forms]![frmContactNew]![ContactID]" And ((tblContactLocation.ContactOfficeStatus) = "current"))

thanks, all these senior moments are making me old.

 

[The_Doc_Man]

The "AND" needs to be inside the quotes, too.

You wrote Dsomething( x, y, "A" and "B") but it needs to be Dsomething(x,y,"A AND B")

 

[KenHigg]

LOCCONCurent = DCount("ContactID", "tblContactLocation", "(tblContactLocation.ContactID=" & [Forms]![frmContactNew]![ContactID] & ") And (tblContactLocation.ContactOfficeStatus = 'current')")

???

 

[Thales750]

If you boys are ever in Washington DC, look me up, I'll buy you lunch.

I seriously mean that.

 

[Thales750]

Hello Guys,

Ken, what do the "&"s do in that line?

And I see that the main problem I was having, I actually tried several different versions befor posting it here, was the use of single quotation marks for values.
Thanks

 

[aman]

Hi Thales

As ContactID has number datatype so the ContactID(Form Control) starts with "& and ends with &" as the following line:

tblContactLocation.ContactID=" & [Forms]![frmContactNew]![ContactID] & "

If suppose it has text data type then it should have started with ' " & and ended with & " '
that means single quotes extra than number data type.

If it has Date datatype then there should be extra # around that rather than single quotes.

I hope its understood.

Cheers

 

[Thales750]

I get it now, it differentiates between data type.

 

[The_Doc_Man]

Between LITERAL datatypes in VBA or SQL.