Dcount Problem

[sdel_nevo]

Hi All

I have a problem with a form that i don't know the syntax for

i have an unbound text box that has this code as it's control source

=DCount("[OrderID]","[Orders]","CustomerID=" & "[Forms].[Customers Details].[CustomerID]")



this works as expected and returns the count of orderID'S based on the CustomerID of the Customer Details Form.


my problem is that i can't get this to only count orderID's that have the Yes/No box "have been invoiced" as true in the Orders Table

can Dcount handle 2 criteria and if so how do i program this? if not what is the best way to produce the required results.

please except my apologies if this has been answered before

Steve

[sdel_nevo]

Hi All

just resolved this issue

for anyone else with the same problem here is the syntax required

=DCount("[OrderID]","[Orders]","CustomerID=" & "[Forms].[Customers Details].[CustomerID] and [Has been Invoiced]=true")

Steve

Steve