Search results

  1. I

    Enter value in a form, run query and display result on form

    I'm a beginner at Access, but the one thing I have leant is there is often a very simple way of doing a task if you know how. So before I start looking at VBA and DAO commands. Is there an easy way of entering a value in a text box, passing to a query to do a count function and then return...
  2. I

    Use of Count in query

    I have created a query in design view which has generated this SQL: SELECT [ACD-C-DataSourceExport].Field2 FROM [ACD-C-DataSourceExport] GROUP BY [ACD-C-DataSourceExport].Field2 HAVING ((([ACD-C-DataSourceExport].Field2) Like "2313*")); This works fine and returns all 265 records bginning...
  3. I

    How do I join tables using a link table in a form?

    Hi All I'm a newbie at access, I believe I understand the basics of relational databases and queries, but I am really stuck on an issue. I have been asked to maintain a directory for our local Scout district. It's currently in a spreadsheet, but is crying out to be a database. Here is what I...
  4. I

    Using a form to amend the search criteria of a query and display results in the form?

    Hi All I'm an MS Access newbie and I was wondering you would be able to help me with a form and query? I've done some googling of the problem and I have come up with the following: I have a table of telephone extentions called "ACD-C" I have a query "called qryRecordedBySite" and I have a...
  5. I

    Picking a value form a list of values in a report

    I have a database which I run for my Scout group. One of the reports I run is the nights away badge. In the report, I produce a list of camps each Scout has attended and calculate the total number of nights. I also have another field that displays the current nights away badge held, so for...
Back
Top Bottom