right()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

Can the right function be used in a DCoun functiont?

vResults2 = DCount("[cont]", "tbcountHold", right([count],3 = 500)

This is not working..

Cont is a text field.
 
I got it... Had a few missing items...

vResults2 = DCount("[cont]", "tbcountHold", Right("[Cont]", 3) = "500")
 
If you are suggesting your new DCount() works, I would be surprised but I
could be wrong.
--
Duane Hookom
MS Access MVP

Mark said:
I got it... Had a few missing items...

vResults2 = DCount("[cont]", "tbcountHold", Right("[Cont]", 3) = "500")

Mark said:
Hello all,

Can the right function be used in a DCoun functiont?

vResults2 = DCount("[cont]", "tbcountHold", right([count],3 = 500)

This is not working..

Cont is a text field.
Click to expand...
Click to expand...
 
You are correct it did not work.. Can this be used in a DCount?

Duane Hookom said:
If you are suggesting your new DCount() works, I would be surprised but I
could be wrong.
--
Duane Hookom
MS Access MVP

Mark said:
I got it... Had a few missing items...

vResults2 = DCount("[cont]", "tbcountHold", Right("[Cont]", 3) = "500")

Mark said:
Hello all,

Can the right function be used in a DCoun functiont?

vResults2 = DCount("[cont]", "tbcountHold", right([count],3 = 500)

This is not working..

Cont is a text field.
Click to expand...
Click to expand...
Click to expand...
 
I don't know what you are attempting to count but this might work:
DCount("[cont]", "tbcountHold", "Right([Cont], 3) = '500'")
--
Duane Hookom
MS Access MVP


Mark said:
You are correct it did not work.. Can this be used in a DCount?

Duane Hookom said:
If you are suggesting your new DCount() works, I would be surprised but I
could be wrong.
--
Duane Hookom
MS Access MVP

Mark said:
I got it... Had a few missing items...

vResults2 = DCount("[cont]", "tbcountHold", Right("[Cont]", 3) = "500")

:

Hello all,

Can the right function be used in a DCoun functiont?

vResults2 = DCount("[cont]", "tbcountHold", right([count],3 = 500)

This is not working..

Cont is a text field.
Click to expand...
Click to expand...
Click to expand...
 
Thank you! That worked.

Duane Hookom said:
I don't know what you are attempting to count but this might work:
DCount("[cont]", "tbcountHold", "Right([Cont], 3) = '500'")
--
Duane Hookom
MS Access MVP


Mark said:
You are correct it did not work.. Can this be used in a DCount?

Duane Hookom said:
If you are suggesting your new DCount() works, I would be surprised but I
could be wrong.
--
Duane Hookom
MS Access MVP

I got it... Had a few missing items...

vResults2 = DCount("[cont]", "tbcountHold", Right("[Cont]", 3) = "500")

:

Hello all,

Can the right function be used in a DCoun functiont?

vResults2 = DCount("[cont]", "tbcountHold", right([count],3 = 500)

This is not working..

Cont is a text field.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top