View Single Post
  #3  
Old November 8th, 2009, 04:10 AM posted to microsoft.public.access.tablesdbdesign
plisvb via AccessMonster.com
external usenet poster
 
Posts: 13
Default Need a little help with syntax

Thanks,

I think it's the right data type because the following code works perfectly
on it's own textbox

=DCount("[OrderID]","Orders","[Transaction Type]=2")



Ken Snell wrote:
Your code appears to be syntactically correct, assuming that [Transaction
Type] field is numeric data type.

Hi Guys,

[quoted text clipped - 20 lines]

Thanks in advance


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200911/1