Search results

  1. A

    VB6 sql query wont recognise all records in my ms Access Union Query

    im having a problem with pulling data from a union query from an access database. the field i am looking at is a Date field (Short Date) and im trying to get all records with dates between date one and date two (date picker control in vb6) im using kan ADO connection as follows If...
  2. A

    Data Type Mismatch

    ok im having problems with the data type mismatch error. this is giving me some grief but simply i am comparing the two fields ExpiryDate (Date)> CurrentDate (Now()) in a query expression to return a '0' or '-1' if the ExpiryDate is larger than the CurrentDate. this works fine. however when i...
  3. A

    Question Aggregate Query Issue

    I think this is an issue that has haunted me for a long time and claims a lot of my loss sleep. i need to create an aggregated query of records, with all fields grouped by except the DateCompleted field which is Max. This is so i can find the last date that an event was completed. simple...
Back
Top Bottom