I IanT Registered User. Local time Today, 21:30 Joined Nov 30, 2001 Messages 191 May 3, 2006 #1 Hi Can anyone see what I have done incorrctly as this does not work! Thanks in advance..... =DCount("[call type]","qryISAHistoryCount","[Label] = 'Call'" And "[User] = 'Craig'")
Hi Can anyone see what I have done incorrctly as this does not work! Thanks in advance..... =DCount("[call type]","qryISAHistoryCount","[Label] = 'Call'" And "[User] = 'Craig'")
KenHigg Registered User Local time Today, 16:30 Joined Jun 9, 2004 Messages 13,291 May 3, 2006 #2 =DCount("[call type]","qryISAHistoryCount","([Label] = 'Call') And ([User] = 'Craig')") ???