> Hi there.

> Using Visual Basic 6, I want to have a report showing all the sales in
> various groups to make it easier to read. I would like to have the sales
> separated into the employee name (asc) and then by the date (desc). I have
> tried for ages to get this to work. I'm sure someone will be able to
easily
> correct my errors in no time.

> The problem at the moment is that all sales are repeated for each date.

> Could you please have a look at it and see if you can get it working
> properly. You can download it from
> http://members.fortunecity.com/hypercharge/report.zip, it's only 95kb.

> Thank you,
>    Shane

> Hi there.

> Using Visual Basic 6, I want to have a report showing all the sales in
> various groups to make it easier to read. I would like to have the sales
> separated into the employee name (asc) and then by the date (desc). I have
> tried for ages to get this to work. I'm sure someone will be able to
easily
> correct my errors in no time.

> The problem at the moment is that all sales are repeated for each date.

> Could you please have a look at it and see if you can get it working
> properly. You can download it from
> http://members.fortunecity.com/hypercharge/report.zip, it's only 95kb.

> Thank you,
>    Shane

> Hi,

> I just took a quick look at your VB app, your Access2K

> and your README.txt objective.

> Here's SQL from a query I tested on your tables that will work for that
> reporting objective:

> SELECT tblEmployees.ID, [FirstName] & Space(1) & [Surname] AS
> EmployeeFullName, tblSales.RecordDate, tblSales.Products,
> tblSales.SellPrice, tblCustomers.Customer
> FROM tblCustomers RIGHT JOIN (tblEmployees LEFT JOIN tblSales ON
> tblEmployees.ID = tblSales.NameID) ON tblCustomers.ID =
tblSales.CustomerID
> GROUP BY tblEmployees.ID, [FirstName] & Space(1) & [Surname],
> tblEmployees.Surname, tblSales.RecordDate, tblSales.Products,
> tblSales.SellPrice, tblCustomers.Customer
> ORDER BY tblEmployees.Surname, tblSales.RecordDate DESC;

> ...OR your rptAllSales grouping should match the above grouping/sorting.
> --
> Calvin Smith
> http://www.CalvinSmithSoftware.com
> "Real-world Source Code Solutions"
> *** http://www.CalvinSmithSoftware.com/CalvinSmithDoesWebsites.htm ***

> > Hi there.

> > Using Visual Basic 6, I want to have a report showing all the sales in
> > various groups to make it easier to read. I would like to have the sales
> > separated into the employee name (asc) and then by the date (desc). I
have
> > tried for ages to get this to work. I'm sure someone will be able to
> easily
> > correct my errors in no time.

> > The problem at the moment is that all sales are repeated for each date.

> > Could you please have a look at it and see if you can get it working
> > properly. You can download it from
> > http://members.fortunecity.com/hypercharge/report.zip, it's only 95kb.

> > Thank you,
> >    Shane

> This question should be directed to a VB group. While many of us have
> experience with VB, we mostly avoid the native VB data reports. There is a
> news group microsoft.public.visualbasic.dataevnreport that might work for
> you.

> Duane

> Thanks for your reply, I tested it and it worked.

> Although, it isn't quite what I was looking for. If you looked at the
"test"
> report I created I had the user name only show up once, then all sales
> grouped under each date instead of the date being displayed for each sale.
> Is it possible to do this without it being repeated. I'm sure it is easy
to
> do, I just don't know how.

> Cheers,
>    Shane

> > Hi,

> > I just took a quick look at your VB app, your Access2K
> tables/relationships,
> > and your README.txt objective.

> > Here's SQL from a query I tested on your tables that will work for that
> > reporting objective:

> > SELECT tblEmployees.ID, [FirstName] & Space(1) & [Surname] AS
> > EmployeeFullName, tblSales.RecordDate, tblSales.Products,
> > tblSales.SellPrice, tblCustomers.Customer
> > FROM tblCustomers RIGHT JOIN (tblEmployees LEFT JOIN tblSales ON
> > tblEmployees.ID = tblSales.NameID) ON tblCustomers.ID =
> tblSales.CustomerID
> > GROUP BY tblEmployees.ID, [FirstName] & Space(1) & [Surname],
> > tblEmployees.Surname, tblSales.RecordDate, tblSales.Products,
> > tblSales.SellPrice, tblCustomers.Customer
> > ORDER BY tblEmployees.Surname, tblSales.RecordDate DESC;

> > ...OR your rptAllSales grouping should match the above grouping/sorting.
> > --
> > Calvin Smith
> > http://www.CalvinSmithSoftware.com
> > "Real-world Source Code Solutions"
> > *** http://www.CalvinSmithSoftware.com/CalvinSmithDoesWebsites.htm ***

> > > Hi there.

> > > Using Visual Basic 6, I want to have a report showing all the sales in
> > > various groups to make it easier to read. I would like to have the
sales
> > > separated into the employee name (asc) and then by the date (desc). I
> have
> > > tried for ages to get this to work. I'm sure someone will be able to
> > easily
> > > correct my errors in no time.

> > > The problem at the moment is that all sales are repeated for each
date.

> > > Could you please have a look at it and see if you can get it working
> > > properly. You can download it from
> > > http://members.fortunecity.com/hypercharge/report.zip, it's only 95kb.

> > > Thank you,
> > >    Shane

> Yeah, I know this isn't the best news group to post this message, but I
> didn't know of any others.

> Thanks for the tip.

> > This question should be directed to a VB group. While many of us have
> > experience with VB, we mostly avoid the native VB data reports. There is
a
> > news group microsoft.public.visualbasic.dataevnreport that might work
for
> > you.

> > Duane