Recent content by RobW

Expr1: Sum([Savings1]+[Savings2]+[Savings3]) Should do it i think

SELECT tblMembers.MemberNumber, tblMembers.FirstName, qry1QtyDNB.QtyDNB2, qry1QtyNotOut.QtyNotOuts FROM qry1QtyDNB, qry1QtyNotOut, tblMembers INNER JOIN tblScoreCard ON tblMembers.MemberNumber = tblScoreCard.MemberNumber;

Thanks for all your help, got round the problem by creating an IIF statement: IIF([QtyNotOut] >0, [QtyNotOut],0)

When I query a query and include fields from a table, the fields duplicate. I sorted this by selecting the join type as "only include rows where the joined fields from both tables are equal". I have two tables and two queries that I want to create a query about. The joins come via the field...

I got that far, but i need a total for each different player. If the individual player has a "Not Out" entry in the HowOut field, it works fine, but if they don't the calculated field does not put zero. Do you know how to sort this?

I am having trouble with the count feature. I am writing a cricket database and I need to count the number of times the words "Not Out" appear in a field (called HowOut). I have tried to put "Not Out" in to the criteria box and then created a calculated field to count that. This worked if the...