Recent content by May Parry22

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

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...

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.

NewField: Left([FieldName],4)

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...

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

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.