Search results

  1. S

    Counting Occurrences

    I have the number 2334566 and need to know; How many times each number appears and then sort them accordingly ie... Number = 2334566 Number and occurrences 2-1 3-2 4-1 5-1 6-2 Results 2453366 I am trying to do this in VB.Net and it is driving me nuts. The number 2334566 is a randomly...
  2. S

    Querying against a Union Query In SQL Server 2005

    I've been using Access for several years and am now switching to SQL Server 2005. Once I have created a union query How can I query against my union? I would assume that I need to name my Union Query but that does not seem to be working for me as I have done to the previous queries that makeup...
  3. S

    Bullets in Access

    I have a interesting problem. I have noticed that there are users that have been looking for a way to add bullets in Forms and Reports. I have just the opposite. I have a linked table that is bringing in "numbered work instructions" ie 1).........2)...... . Access is automatically putting a...
  4. S

    having probles with instr in my query

    I need to be able to take a list of instructions like this one, that is in a table, and have it break out in a query so that when I go to use it in a report it will look like the second example. 1) Set the oil out so that it is at room temperature. 2) Mix the oil and the alcohol together. 3)...
  5. S

    Len, Char, instr Not sure what to use or how to use it

    I need to bee able to query out all entries that are not like the following format S01-19-01-3. Users are entering incorrect data such as So1-19-o1-3, S0119-01-3, S01-19-01-3. Users are supposed to enter the data with One letter, 3 dashes and 7 numbers. If they enter any other way I need to...
  6. S

    IIF Help

    How do I make this Work. I know it should be easy but I just can't get it. If text159 is blank and the Stage field is equal to 4 then make blank otherwise show the Quantity. =IIF([Text159]="", and [Stage]=4,"",[Quantity]) So if both are True then Blank but if [Text159] is false and [Stage]...
  7. S

    DSUM / Running Sum In query

    I have been trying to get this all night. This was my last attempt. I know it is all wrong and messed up but after 10 hrs I go for help. There is no date field to work with. Expr2: DSum("[Amount]","[List]","[Item]=" & [Item] & "and [FinItem]>0")+0 But it ended up like this. Item...
Back
Top Bottom