Re: group by report


hans,
First off, thanks for the quick reply.

okay a little background, I know php and mysql, so most of the stuff i
do is moving client to server to client.

I now just started working for a company that uses access and great
plains. I have yet to meet with the Database Admin, so i do not know
the table structure or query structure yet.

Once I get that down, i will start writing the queries myself.

untill then i am forced to use the access program that everyone else
has. in there you can pick an open order report and then it will send
it to excel, (i don't know how, like i said i don't work with microsoft
products much). the excel spread*** then has about 15 columns with
various data in them for each item

in order to make the report more readable, we sort based on the req
ship date and then by order number.

we also delete some of the columns that we don't needs (this is why i
want to set up my own queries, because you can see how inefficient this
is).

anyway, so I set up a macro that pretty much does that, and adds a
title and date, so we can forward the report to others.

the problem is that there is no break from one group or orders to the
next, so it is hard to see a summary. I have been going through it by
hand and inserting two blank rows in between each group of orders so it
is easier to read. I also add a sum function to get the total sale from
the group of each unique order number.

after doing about 200 records i was fed up and thought there had to be
a way to make a macro do this, but i don't know how to set it up so it
looks for unique value groups and preform a task at the end of the
group.

i hope that clearifies it somewhat.

like i said, if they had php running on the server i could pull up a
webpage that would look nifty, but unfortunately they do not, and i
find VB very confusing, but then again i never really use it.

Thanks for the help!!!
travis


--
trav
------------------------------------------------------------------------
trav's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31420
View this thread: http://www.excelforum.com/showthread.php?threadid=511138

.

Loading