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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Inner Join problems
Hi i got this Query that gives me the results of the most recent dates. It looks like this SELECT t.id, t.PumpgropsID, t.DateNeed, t.DateCleaned FROM tblSlamTomning AS t INNER JOIN [SELECT PumpgropsID, MAX(DateNeed) AS MaxNeed FROM tblSlamTomning GROUP BY PumpgropsID HAVING MAX(DateNeed) >...- daffelito
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Date Query confusion.
Hi, I have a problem with a query that's going to show the latest dates. First i got a table with 4 columns 1. ID (Primarykey) 2. WorkplaceID (Child to Primarykey in other table) 3. DateNeed 4. DateDone This table is storing information when a workplace needs to be cleaned and when it's been...- daffelito
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Query based on two tables.
Hi I am trying to get an value to an unbound textbox in a form, but something in my query just returns the "query statement" it selfe in the textbox. it looks like this: Me.Pumptyp.Value = "SELECT tblPumpsorter.Pumpnamn" & _ "FROM tblPumpsorter" & _...- daffelito
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
