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

Query Quandary

Status
Not open for further replies.
CluelessRink

CluelessRink

Technical User
Jun 5, 2004
53
US
I have a text box set up on my form using the following DSum statement to get data via a query...
Code: 
=DLookUp("SumOftotalSales","qry_sales_by_dept_es","transdate=#" & [transdate] & "#'")
It isn't working correctly though, I am getting #Error.

What do I have wrong?

 
Sort by date Sort by votes
Get rid of the single quote

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Ah, I do wish all my troubles were so simple.

Thanks.

Rink
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
276
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
203
dhookom
dhookom
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
189
dhookom
dhookom
applestoapples
  • Locked
  • Question
Make Table Query sort not working 1
Replies
2
Views
102
Andrzejek
Andrzejek
PLCBeetle
  • Locked
  • Question
Passing a form value to query...
Replies
6
Views
142
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top