Search results

  1. A

    Help - Simple Query

    I have a SQL database which I am trying to run some simple queries on in MS Access. The first field contains Compamy Names: Activ Technology Services Limited Active Network Solutions Ltd Group Active Technology Systems Acute Sales Limited Wave-form Solutions Limited Addwell...
  2. A

    Dashboards - Creation

    I have a series of queries and reports in Access 2007 that I would like to put on a dashboard for easy access and to make my database more antithetically pleasing. Is this possible? If so do I have to create macro's to run the queries and reports and then enter them on the dashboard. Any...
  3. A

    Working with Text

    I am trying to create a query that will select a piece of text that always appears after another piece text eg: Request for manufacturers RMA Number sent to Zebra. RMA No: 318937 The words RMA No: are standard in every record. I want to display the following 12 characters the follow after...
  4. A

    Linked tables from sql

    I have made an ODBC link to a SQL database on our companies server so that I can interrorgate the table for information. This is working well and I can produce a form showing the data I want. My question is if I delete any text from a field on the form it deletes the information on the server...
  5. A

    Totals from duplicates query

    I am trying to add the column 'CountOfDuplicates' to show a total in in a query or report. Example: Acceca 50 I need the report only to show the manufacurers name and the total for that manufacurer. I have tried to do this in a report however it shows me every line. Can somone...
  6. A

    Counting the number of instances

    I am running a query where the result shows multiple instances of a word ('Aceeca') and I can see from the Record navigation bar that there are 62 instatances of the word. My question is, How can I show within the query or even a report how many times that word appears?:confused: Grateful for...
  7. A

    Query Question / Caluulation

    I have crated a small database which produces a query (see attached excel file) I want to be able to add up all the 1's at the end of the column. I'm sure there must be and expression to fit the bill however I have know idea where to start. I am also trying to find either in Access or on the...
Back
Top Bottom