Recent content by antoka05

  1. A

    SQL - join three fields - same table into one column

    UNION command automatically delete duplicated records. If you want all records use 'UNION ALL' and not 'UNION'. Regards, Antonio
  2. A

    Query shows more digits after comma than there is in a table

    Try to use 'round' function: SELECT Round(Sum(Appended.sum),2) AS sssum FROM Appended; Regards, Antonio
  3. A

    SQL - join three fields - same table into one column

    Try with: Select <field 1> from <table> as <Alias> UNION Select <field 2> from <table> UNION Select <field 3> from <table> Regards, Antonio
  4. A

    Query Problem Please Help!

    See attached file in wich I inserted queries [NEW Query1] and, if PRESS and PressID are not compatible, [NEW Query2]. Regards, Antonio
  5. A

    Select records in Table 1 that are not in Table 2

    You can also use this query: SELECT Reviews.FK_ReviewID FROM Reviews LEFT JOIN Results ON Reviews.FK_ReviewID = Results.FK_ReviewID WHERE Results.FK_ReviewID is null and reviews.FK_StatusID = 3 Regards, Antonio
  6. A

    Mean Time Between Failure

    You may try to use this query> SELECT [s/n], Max(open_date) - Min(close_date) AS Date_Difference FROM myTable GROUP BY [s/n]; This query doesn't work if you have more than two records for each s/n. Regards, Antonio
  7. A

    ComboBox and form

    You need to change the RowSource properties (presents in Data tab) of the second combobox. Then, in the code of the first combobox, put the instruction: Combobox2.Requery I've attached a sample hoping it can help. Regards, Antonio
  8. A

    query equals text box

    Glad to know it helped you. Regards, Antonio
  9. A

    query equals text box

    Try with this code... I hope it's what you need: Dim rs As Recordset Dim query As String Set rs = New ADODB.Recordset query = "select count(*) from [qryCustNo] where qryCustNo.<myfield> = """ & Me.txtCustNo & """" recordsMatchingText = 0 rs.Open query...
See more
Back
Top Bottom