Search results

  1. C

    Query answers in different columns

    Hi Gender Q: (e.g.) Male or Female? How do I get (e.g.) Male answers in one query column, and (e.g.) Female answers (to the same question) in query column 2? Repeating the question, and specifying the different answers, does not work.
  2. C

    Moving data from one table to another

    Hi. SELECT * FROM [Patient Details] where [Life Status] = "Deceased" COPY INTO [Deceased Patients] Delete * from [Patient Details] where [Life Status] = "Deceased" Access says missing operator. Any idea which one?
  3. C

    Combo selection locks current form

    Combo selection 4 selects'dead patient'. Current form (part of continuous form view) must then lock unless password allows access. Not sure how to do this without locking the other forms as well?
  4. C

    Financial years in a query

    Hi. I've got a working query: SELECT [CM Database].[Age Range], Count([CM Database].[Age Range]) AS [Count], Format([Date Contacted],"yyyy") AS [Year] FROM [CM Database] GROUP BY [CM Database].[Age Range], Format([Date Contacted],"yyyy") HAVING ((([CM Database].[Age Range]) Is Not Null) AND...
Back
Top Bottom