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!

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

Access Query Question/Problem

Status
Not open for further replies.

Monguse

Programmer
Mar 11, 2002
63
US
I am using the below Querry and it works great as is, however I need it too sort by one more field and I just can't seem to get it set-up righ can one of you please take a look and help me out.


Adodc1.RecordSource = "SELECT * FROM Schedule WHERE Date BETWEEN #" & StartDate & "# and #" & EndDate & "# ORDER BY Date And ORDER BY WONum"

The section "And ORDER BY WONum" is where I get the error.

Thanks "The beauty of the second amendment is, that it will not be needed until they try to take it." - Thomas Jefferson

WebMaster:
 
It should be:
"ORDER BY Date, WONum" Kyle [pc2]
 
Thanks!

I figures it would be a simple fix.. I just don't have a lot of experance writting querries. It works great now. "The beauty of the second amendment is, that it will not be needed until they try to take it." - Thomas Jefferson

WebMaster:
 
KyleS,

Where did you get the cool pic? Are there more like it?

Onwards,

Q-
 
Q-

If you're referring to my computer geek I got it from here a while back and it's no longer on the emoticons/smileys menu. anyway it's [ p c 2 ] [pc2]

There's also a [ p c 1 ] [pc1]


Kyle [bobafett]


[pc2]
 
Hi!
I need to check the validity of Start date and times entered by the user before I use them for calculation. There are a maximum of 10 fields for each (Start Date and Start Time). I dont want to write 20 queries for this purpose. Is there an easier way to do this? I would appreciate any feedback.

Thanks,
accessbabe. :-{}
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top