After group by date, the value is different.

[ngaisteve1]

Hi! I have a complicated problem here. So, I think it is better if you can login to take a look of my problem. User ID and password is tester

http://portfolio.findingsteve.net/production_system/member_login.asp

There are 2 sample sales report inside. The focus is DK No 0826 which is in page no 6 in sales report 2 and date 22-05-2004 in sales report 1.

How come after group together in one date, the value change?

My code is in

http://portfolio.findingsteve.net/production_system/sample_sales_report_code.zip

I have put necessary code there. I zip it because I don't how to display my length code. Thanks.

[eRad]

I can't seem to find what you are referring to... how does one 'group by date' ?

I found the entry - 0826/2004 22-05-2004 Teo Hang Sam Dai-Dan Co., Ltd.
...but there doesn't seem to be any options for sorting/grouping. If i try to click on the report to view it, access is denied.

[ngaisteve1]

Sorry, now the link should be fine.

Actually what I meant by group by date is eg I have 5 dk no

dk no: 0826
dk no: 0824
dk no: 0823
dk no: 0825
dk no: 0826.1

with all the date is 22-05-2004.

So, when you go to sales report 1 which is group by date, these 5 dk no will be one because all of them is 22-05-2004.

Actually, I'm doing this way just for dig deep to find out what is the problem.

[afterburn]

for a group by to work you must have an item that will be duplicate and a non-duplicatable item. Like your DK.... that is a primary key I would assume.