Re: group by report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


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 spreadsheet 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

.

Relevant Pages

  • Re: get_memory_usage() and mysql resource usage?
    ... suspect memory or resource limits in MySQL might be the problem. ... I have a set of php scripts which query the database with some pretty ... report, it take about 30-45 seconds to generate, and 5 MB of memory, ...
    (alt.php)
  • Stuck & Need Help with "Generate Report"
    ... I need to complete this "Generate Report" page for my employer and I'm ... What I want to do is create a single file to display and process the ... can I have this page split PHP | HTML |PHP when using the "if ... php file so that if sumbitted, here is the query and output BUT if not ...
    (comp.lang.php)
  • Re: PHP has encountered an access violation...
    ... Some kind of internal bug in PHP. ... Maybe because if no one ever took the time to find problems and report ... running in 'debug' mode. ...
    (comp.lang.php)
  • Re: [PHP] Hide Warnings
    ... still writing warnings to screen. ... My ISP is using PHP Version 4.3.10 if that is any help. ... // Reporting E_NOTICE can be good too (to report uninitialized ...
    (php.general)
  • Re: PHP has encountered an access violation...
    ... But, if that was actually the case, a <refresh> wouldn't ... Some kind of internal bug in PHP. ... Maybe because if no one ever took the time to find problems and report ...
    (comp.lang.php)