<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 5.00.2920.0" name=GENERATOR>
<STYLE>P.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0cm 0cm 6pt
}
LI.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0cm 0cm 6pt
}
DIV.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt; MARGIN: 0cm 0cm 6pt
}
H2 {
FONT-FAMILY: Arial; FONT-SIZE: 14pt; FONT-STYLE: italic; MARGIN: 12pt 0cm 3pt
}
H3 {
FONT-FAMILY: Arial; FONT-SIZE: 13pt; MARGIN: 12pt 0cm 3pt
}
H4 {
FONT-FAMILY: Arial; FONT-SIZE: 12pt; MARGIN: 3pt 0cm
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P.Code {
FONT-FAMILY: "Courier New"; FONT-SIZE: 12pt; MARGIN: 6pt 0cm 6pt 17.85pt; punctuation-wrap: simple
}
LI.Code {
FONT-FAMILY: "Courier New"; FONT-SIZE: 12pt; MARGIN: 6pt 0cm 6pt 17.85pt; punctuation-wrap: simple
}
DIV.Code {
FONT-FAMILY: "Courier New"; FONT-SIZE: 12pt; MARGIN: 6pt 0cm 6pt 17.85pt; punctuation-wrap: simple
}
SPAN.EmailStyle18 {
COLOR: windowtext; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US link=blue vLink=purple>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN
class=017201110-11022003>D<SPAN class=017201110-11022003>ear
group,</SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN
class=017201110-11022003><SPAN
class=017201110-11022003></SPAN></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=017201110-11022003>I am
strugling with the following. I need a report which shows the
following</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003>
Sales until this month Sales this month
Total Sales</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003>Supplier</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003>
Customer 1
1000
100 1100</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003> </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=017201110-11022003>I have
tried to do this with </SPAN></FONT></DIV>
<OL>
<LI><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003>cross-tab query: this does not work because I do not
know how many months there are.</SPAN></FONT></LI>
<LI><FONT color=#0000ff face=Arial size=2><SPAN class=017201110-11022003>two
reports in one: If a customer misses in a certain month the rows are not equal
anymore</SPAN></FONT></LI></OL>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003>Neither option works very well. I am sure there is a
simple solution for this.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003>Suggestions,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=017201110-11022003>Thanks, marcel</SPAN></FONT></DIV></BODY></HTML>