Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
superkid
Starting Member
5 Posts |
 Posted - 2003-07-09 : 09:07:19
|
| Good Day,1) I am currently trying to retrieve records from two tables. I will be pulling about 10 records from the query using recordsets. But i have a problem bec there is name both in worker table and employer table.If i were to use rsUser("Nmae") to gather the data, there will be an error. How do i get about this problem? Any suggestions?strSQL = "SELECT * FROM Workers,Employers WHERE Workers.WPValidTo <= DateValue('" & dtMonth & "*') AND Workers.Name = Employers.Name ORDER BY Workers.Employers"2) I am also trying to compare the dates using just the month and year and have some trouble getting it rite. Please do forgive me for my amatuerish questions because i am new to this.Below is my sql statementstrSQL = "SELECT * FROM Workers,Employers WHERE Workers.WPValidTo <= DateValue('" & dtMonth & "*') AND Workers.Name = Employers.Name ORDER BY Workers.Employers"Please do give me a hand in this.Thanks alotMark~ |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-07-10 : 03:12:23
|
| rsUser("Workers.Name")orrsUser("Employers.Name")- Vit |
 |
|
|
superkid
Starting Member
5 Posts |
Posted - 2003-07-12 : 10:07:39
|
| Thank a lot Vit~ |
|
|
|
|
|
|
Access SQL comparing dates and retireving records