count null record in fileds dao

S

sal21

i want to count all records NULL or with LEN=0 in ANAGRAFICA1 in field
APPELLATIVI but have error...???

piece of my conn:
Set DB1 = DBEngine.OpenDatabase("F:\ANAGRAFICA.mdb")
Set RSD1 = DB1.OpenRecordset("ANAGRAFICA1")

Set RSD1 = DB1.OpenRecordset("SELECT COUNT(*) AS CAMPO_VUOTO FROM
ANAGRAFICA1 WHERE APPELLATIVI IS NULL")
 
M

Michel Walsh

DCount("*", "ANAGRAFICA1", " 0=len(APPELLATIVI & '') "


where what follows the & is two single quotes, not a single double quote.




Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count null record in filed with DAO 1
Union query (I thinK) 4
ALTER TABLE syntax error 4
Revision to form VBA Error 6
query on query 1
Copying All Records from a Query to a Table 2
How to count consecutive records base on 2 groupings 0
Need help with DefaultView.RowFilter 2

Top