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!

Register Log in
  • 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!

Recent content by daffelito

  1. daffelito

    Inner Join problems

    No help needed, i solved it by my selfe. All i had to to was to create a relation between the query and the other table, and then create an other query.
  2. daffelito

    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) >...
  3. daffelito

    Date Query confusion.

    Thanks, i will try this. Thank you verry much. It would be so nice to see this work...
  4. daffelito

    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...
  5. daffelito

    Query based on two tables.

    :) ok, thanks
  6. daffelito

    Query based on two tables.

    Ahh, thank you mate! That worked like a charm. I´m quite a newbee to this so it's kind of hard to know when to use SQL or when to use VBA.
  7. daffelito

    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" & _...
See more

Part and Inventory Search

Back
Top