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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DCount in Query

Status
Not open for further replies.
jjb373

jjb373

MIS
Feb 4, 2005
95
US
Is there any way to get a DCount in a query? I have a parameter in the query. I keep getting the result of #Error

Here is my formula:
=DCount("[Prospective Documents]","Late",([Prospective Documents]-[Date of Appointment])>1)

My query askes for a start date and end date.

Or can I somehow refer to those two parameters in my formula where clause section???
 
Sort by date Sort by votes
I forgot to mention, this formula is in a textbox in my report footer.
 
Upvote 0 Downvote
Post the entire query, lets see...
You are getting error because ([Prospective Documents]-[Date of Appointment])>1 is not enclosed in bouble-quotes in DCount.

Regards,
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
244
OzFoxy
OzFoxy
C
  • Question
Query expression negative to a 0
Replies
6
Views
360
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
865
strongm
strongm
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
4K
combo
combo
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo

Part and Inventory Search

Sponsor

Back
Top