hi all,
i need to build a crystal report that show the total sum of employee's absence per month and per year in a row. it means that i have to count the sum of one field twice based on the period time. meanwhile i have to do it at once since i have to put both values in a row.
i've tried to do it from VB 6.0 and access the database with the SQL commands n ADODB connection. but i guess i can't do
SELECT COUNT(field) .... WHERE (conditions) 2 times in 1 access at a time.
Can anybody please give me a help or clue or another way, i just need both values to show up in a row
thx before :) :)

The first trick, Maria, is to post in the proper forum- this way the people who know the subject can reply.

I am moving your post to a more appropriate forum.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee