Hi
I've spent quite a bit of time today playing with this, and have finally got it working, using the construct below. Tried the cdate and Chr(34) options, and got things pretty close, but the breakthrough came when I replaced the 'startdate / enddate' names with the text box names. Startdate and Enddate were the text box captions. I would have thought I would be able to use the caption names?
Anyhow, I might now go...
Stuart Owen
Last Activity: Dec 30 '07, 12:25 AM
Joined: Jun 11 '07
Location:
-
Hi
Put the code into the query as shown, but no joy. Played around and made a few changes, but still no luck.
When you use the chr(34) approach, do you take the " out? Seems that chr(34) is the ascii code for ", so you wouldn't use both, would you?
Will try working with the cdate function as well, although I've made both the date format in the text box on the form, and in the query, the same...Leave a comment:
-
Hi
I hope the major interruptions that you talk about are not too daunting for you. Please don't worry about this little problem at all. Have really appreciated your input thus far.
For your interest, I've copied the query below (copy and paste this time). Can't see any spaces in the words.
regards
stu
SELECT [hours worked].Hoursworked, [hours worked].Date, Employees.Emplo yeeName,...Leave a comment:
-
Hi
Putting the brackets around the 'startdate' / 'enddate' didn't make any change. In fact, when I went back in to look at the query, the brackets weren't there any longer. Made the changes again, saved everything, but still same results.
Interested in any other suggestions you might have.
cheers
stuLeave a comment:
-
Hi and thanks for the quick response: Here goes:
SELECT [Hours worked].Hoursworked,[Hours worked].date,Employees .EmployeeName,S uppliers.Suppli erName,Employee s.NonManual
FROM ([Hours worked] INNER JOIN Employees ON [Hours worked].Employee = Employees.Emplo yeeNumber) INNER JOIN Suppliers ON Employees.Compa ny = Suppliers.Suppl ierCode
WHERE ((Employees.Emp loyeeName) like "*" & Forms!frmQBFDra ft2!Text0 &...Leave a comment:
-
Query by form
Hi, I'm a relative beginner to Access, and have just found out how to construct a 'query by form' using the SQL, Select/From/Where approach. With the addition of a few wildcards, I've got a form with a couple of text boxes, requiring just a letter or so, to pull out 'like' information. So in order to do this, I have an 'and' statement, linking the two expressions relating to each field (which in turn have 'or' statements linking the wildcard / is...
No activity results to display
Leave a comment: