Syntax

[Moose222]

I have a report that is writeen in DB3, and I am converting it, I need help converting the following equation to Access

count for gcflag = "G" .and. order ' ' to tempvarg


I would take it that I should be able to utilize dcount or dsum to get the answer to this report, how about the blank space for the order column?

Thanks,
Jim Nelson

 

[jebry]

Hi Jim!

Try this:

DCount("gcflag", "YourTableName", "gcflag = 'G' And order = ' '&quot

The aggregate functions have the the general format:

DFunction(Your field as a string, your domain(table or query) as a string, your criteria as a string)

hth Jeff Bridgham
bridgham@purdue.edu

 

[Moose222]

Jerby,

Thanks for writing, I am still coming up with an answer of "0". If "GCFLAG" is a coluumn and "ORDER" is a column in the db, would both have to be in ""?

I am just guessing at this point.

Thanks in advance for any help,
Jim

 

[jebry]

Hi!

Well, there is another thing that could be different. If DB3 is like SAS then when you put in order = ' ', what you are looking for is an empty string. In VBA you would need to put order = '' to look for an empty string.

hth
Jeff Bridgham
bridgham@purdue.edu