Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DCount "like" 1

Status
Not open for further replies.
lars7

lars7

Technical User
Aug 16, 2005
817
GB

Hi There,
Is it possible to do a "like" in a Dcount I tried this but it doesn't like it.

cntAll = DCount("[Pay Number]", "tblAcute", "code = 'n*'")
 
Sort by date Sort by votes
You said it yourself, 'like' :)
[tt]cntAll = DCount("*", "tblAcute", "code Like 'n*'")[/tt]
 
Upvote 0 Downvote
Hi Remou,
I tried that but left the "=" in. :~/
Thanks as always.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
248
combo
combo
IrishJim
  • Locked
  • Question
How do I capture the "digital signature", for display in my Form header?
Replies
0
Views
270
IrishJim
IrishJim
Kennelbloke
  • Locked
  • Question
Wierd DCount issue. Someone please enlighten me. 1
Replies
3
Views
201
combo
combo
torquinian
  • Locked
  • Question
Any Like for Like replacement for Calendar in Access 2003? 1
Replies
8
Views
272
Axworthy
Axworthy
lameid
  • Locked
  • Helpful tip
DoCmd.OutputTo Error 2501 "The output action is cancelled by the user".
Replies
0
Views
299
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top