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 statement
strSQL = "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 alot
Mark~
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-07-10 : 03:12:23
|
rsUser("Workers.Name")
or
rsUser("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