It looks like I have to revamp my baby a bit, and was looking for some advice/assistance.
[fluff]
right now I use a stored procedure in SQL to process our various office phone lists. The report was pre-formatted to take the output from the SQL server one way, mainly sorting by last name. now that the use of this database is expanding to other cities, they each seem to need a different output style. So now I am stuck with either dynamic SQL (have been told to try and stay away from that) and having a more raw output from SQL then do the sorting in Access. So I am here for the latter.
[what I need]
So now I am looking at getting just the plain data from SQL, then based on what the user wants to sort by (drop down selection so it is very specific), I need to then create a header field (vba Left() of the sorted field), then generate the report that would do the sort. Hopefully all through VBA...
first step:
I run my pass thru (leaving out the bloat):
This was created over a year ago, and has not changed. I have to admit that I was quite green when I coded this, and do not remember all that I went through to get it like this. knowing what I know, I would need to insert some code before the DoCmd.OpenReport. here's where I am going to need help....Please Login or Register to view this content.
from the data I get from the pass through, I need to then generate a new query so that I can create my Header field. I just don't know where to start. Like I said, this baby has been self sufficient for over a year, and my mind got stale... After the qdf stuff, how do I then take that and build a query that then calls a report?
Thanks.
Bookmarks