DCount Problem

[DS]

I have a DCount that isn't working, I think its the criteria part. Its
says missing Operator.

Me.Text18 = DCount("EmployeeID", "Employees", EmployeeID & " = Me.TextD")

I tried This Also..

Me.Text18 = DCount("EmployeeID", "Employees", "EmployeeID = Me.TextD")

This says Operation Cancelled

Any help, as always appreciated.
Thanks
DS

 

[SusanV]

Try Me.Text18 = DCount("EmployeeID", "Employees", "EmployeeID = " &
Me.TextD)

 

[Jeff O via AccessMonster.com]

DS, I believe whats missing here are proper single quotes. try:
Me.Text18 = DCount("EmployeeID", "Employees", [EmployeeID] = "'" & Me.TextD&
"' ")
(it hard to see but there are single quotes before and after the Me.TextD
value)

/Jeff

 

[Jeff O via AccessMonster.com]

DS, I spoke too soon. Here is the proper sequence. I tested it.
"[status] = '" & stat & "'")

Me.Text18 = DCount("EmployeeID", "Employees", "[EmployeeID] = ' " & Me.TextD
& "'"

/Jeff

DS, I believe whats missing here are proper single quotes. try:
Me.Text18 = DCount("EmployeeID", "Employees", [EmployeeID] = "'" & Me.TextD&
"' ")
(it hard to see but there are single quotes before and after the Me.TextD
value)

/Jeff

I have a DCount that isn't working, I think its the criteria part. Its
says missing Operator.

[quoted text clipped - 10 lines]

Thanks
DS

 

[DS]

DS, I spoke too soon. Here is the proper sequence. I tested it.
"[status] = '" & stat & "'")

Me.Text18 = DCount("EmployeeID", "Employees", "[EmployeeID] = ' " & Me.TextD
& "'"

/Jeff

DS, I believe whats missing here are proper single quotes. try:
Me.Text18 = DCount("EmployeeID", "Employees", [EmployeeID] = "'" & Me.TextD&
"' ")
(it hard to see but there are single quotes before and after the Me.TextD
value)

/Jeff

I have a DCount that isn't working, I think its the criteria part. Its
says missing Operator.

[quoted text clipped - 10 lines]

Thanks
DS

Thanks, Jeff.
That did it
DS

 

[DS]

Try Me.Text18 = DCount("EmployeeID", "Employees", "EmployeeID = " &
Me.TextD)

Thanks Susan, problem solved!
DS

 

[Jeff O via AccessMonster.com]

Your Welcome...

/Jeff

DS, I spoke too soon. Here is the proper sequence. I tested it.
"[status] = '" & stat & "'")

[quoted text clipped - 19 lines]
Thanks, Jeff.
That did it
DS