Problem in calculation in query

[Gina Whipp]

Coco,

Sounds like you didn't undertand my last posting. Can you send me the
database? I will not be able to look at it right away but I will look at it
later today and *adjust* the query. OR you could to help and read about
Totals in queries, which you should probably do anyway. It's always hard to
modify anything when you don't fully understand it.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Coco111 via AccessMonster.com]

The problem has been solved. thanks.

Coco,

Sounds like you didn't undertand my last posting. Can you send me the
database? I will not be able to look at it right away but I will look at it
later today and *adjust* the query. OR you could to help and read about
Totals in queries, which you should probably do anyway. It's always hard to
modify anything when you don't fully understand it.

 

[Gina Whipp]

Coco,

Glad to hear that... If you feel like it you could post your solution so
others can benefit.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Coco111 via AccessMonster.com]

I just remove grouping in query and it give me correct figure now...thks...
coco

Coco,

Glad to hear that... If you feel like it you could post your solution so
others can benefit.

The problem has been solved. thanks.

[quoted text clipped - 12 lines]

 

[Gina Whipp]

Tahnk you for sharing!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I just remove grouping in query and it give me correct figure now...thks...
coco

Coco,

Glad to hear that... If you feel like it you could post your solution so
others can benefit.

The problem has been solved. thanks.

[quoted text clipped - 12 lines]

Actually, im not very sure also cos im just modify it from northwind
template.

 

[Coco111 via AccessMonster.com]

I must thank you for your help and guide all along...

Coco,

Glad to hear that... If you feel like it you could post your solution so
others can benefit.

The problem has been solved. thanks.

[quoted text clipped - 12 lines]

 

[Gina Whipp]

Coco,

You are most welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I must thank you for your help and guide all along...

Coco,

Glad to hear that... If you feel like it you could post your solution so
others can benefit.

The problem has been solved. thanks.

[quoted text clipped - 12 lines]

Actually, im not very sure also cos im just modify it from northwind
template.