How do I make Dsum with 3 criteria and is the 1st criterion numeric and are the last 2 texts?
F Frank Dulk Jul 29, 2003 #1 How do I make Dsum with 3 criteria and is the 1st criterion numeric and are the last 2 texts?
J John Vinson Jul 29, 2003 #2 How do I make Dsum with 3 criteria and is the 1st criterion numeric and are the last 2 texts? Click to expand... DSum("fieldname", "domainname", "NumberField = " & iVal & " AND [Textfield1] = '" & str1 & "' AND [Textfield2] = '" & str2 & "'")
How do I make Dsum with 3 criteria and is the 1st criterion numeric and are the last 2 texts? Click to expand... DSum("fieldname", "domainname", "NumberField = " & iVal & " AND [Textfield1] = '" & str1 & "' AND [Textfield2] = '" & str2 & "'")
F Frank Dulk Jul 29, 2003 #3 ok. How do I do go look for a value that this inside of a query? John Vinson said: How do I make Dsum with 3 criteria and is the 1st criterion numeric and are the last 2 texts? Click to expand... DSum("fieldname", "domainname", "NumberField = " & iVal & " AND [Textfield1] = '" & str1 & "' AND [Textfield2] = '" & str2 & "'") Click to expand...
ok. How do I do go look for a value that this inside of a query? John Vinson said: How do I make Dsum with 3 criteria and is the 1st criterion numeric and are the last 2 texts? Click to expand... DSum("fieldname", "domainname", "NumberField = " & iVal & " AND [Textfield1] = '" & str1 & "' AND [Textfield2] = '" & str2 & "'") Click to expand...
