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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problems with SQL Query and putting into a recordset
I am trying to put an SQL query result into a recordset. It only puts one entry into the recordset and I know there are multiple results from the query. How do i get all of the results fo the query to go into the recordset and can't I put the recordset into a list box or some other way of...- sbarlow
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
max date less than current
I currently have a table that contain a list of salary numbers and dates. Each salary number has more than one date. I need to get a table containg salary number, *date, and max date less than *date. So far have been unable to achieve this, Please Help.- sbarlow
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
