Search results

  1. M

    recordcount

    Jon, DateOfCount is obviously a Date/Time field. I think we should use the # signs to surround the value of Now() rather than using the single-quotes. May
  2. M

    calculation to change value from DOB to age in VB, not what u thnk

    A query has three views: Design, SQL and Datasheet. You can switch the query amongst these three views from the View menu or from the drop down list of the button on the toolbar (normally it's the first button on the Query Design toolbar unless you have customized it.) When you start a new...
  3. M

    missing operator in where not exists

    I tried many ways to use NOT EXISTS in a query, but they either gave me a syntax error or just returned all the records. Can I use NOT EXISTS instead of NOT IN? Is there any difference in the two? I would appreciate any help. Thanks in advance.
  4. M

    part of field

    NewField: Left([FieldName],4)
  5. M

    Query for Sorting serial numbers

    Jon, I need to sort a Code field in a similar fashion. The Alpha part of code varies from 2 to 4 characters and may include a numeric digit eg Code 1212 2383 3356 59BB 62BB 114BB 33AA3C 56AA3C 991B2DX 998B2DX 261ALL 268ALL 44AL2 103AL2 There are over 80 Alpha groups. I don't know how to write...
  6. M

    Nz() in crosstab query

    Use Nz(Sum([tblSales].[Quantity]))+0 Take a look at this thread http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=60971
  7. M

    Currency

    You have pointed out the potential pitfall of using Nz([something],0) I used Nz()+0 and found that it worked. I also found that to use Val(), we still had to use Nz() to convert the Nulls to string 0s first.
Back
Top Bottom