Search results

  1. M

    I need help with a function code (getting a number from a string field, data manip.)

    Hi! The function I need is similar to the solution of this thread . But I need to addapt it to my own string field. I present some examples of the data I need to manipulate: "Record 12345/AOP/2007" "Record 0123/2008" "Note N° 56478/DDD/2008" "Data 1114/2007" etc I will highlight the number I...
  2. M

    Getting only the last date per record in a primary table

    I need to build the following query: I have 2 tables: tblBusiness tblInspection tblShops have an ID, an adress, bussines name, owner name, etc every Shop can be inspected many times. A inspection can be futile if the store is closed. If the store is open, the inspection is made, and as result...
  3. M

    Getting only the last

    I need to build the following query: I have 2 tables: tblBusiness tblInspection tblShops have an ID, an adress, bussines name, owner name, etc every Shop can be inspected many times. A inspection can be futile if the store is closed. If the store is open, the inspection is made, and as result...
  4. M

    Refering to the current record in a query

    It is possible to refer in a SQL statement to the "current" or "actual" record? I want to base the querry in the present value of two related tables. I will try to show you what I have to do, maybe you can give an alternative solution. These are the tables: tblTeam (idTeam, TeamName...
Back
Top Bottom