Recent content by bordway

Ref thread1462-1567557 I have the same request/problem as mentioned in this post. Duplex printing where a report has page breaks on a group. Currently new groups can start on the back of a page. Users need all groups start on the front of the page. i.e insert a blank page if the starting page...

>>This is a SQL Server forum... check to see if there is one for Open Edge OK thanks. I forgot this was the ODBC connection to a legacy Progress version - SQL but limited. I will test Row_Number on the newer versions All MS SQL & they need the same updates. Bruce O

>>The important part here is the Row_Number stuff. Thanks for the reply, good to know. Unfortunately not an option in this case. I'm working with an old version of OpenEdge 10.1B via ODBC >>> the ROW_NUMBER function is not supported in OpenEdge and there is currently no equivalent function...

F.Y.I. It turned out I really needed a view and the ability to return multiple records. I couldn't figure out how to get it to work in just one statement. So ended up making one view & calling it in the other as follows. It works but I'd be interested in suggested alternatives -- Sub View...

>>Top 1 Yes, the one row is all I need for what I'm doing. Thanks for the suggestion

Hi, Can you help me with this one? I need to select Revision a parts - from Approved (True) Revisions only - the revision with the MAX Effective date So from these part revisions PartNum___Rev___Approved___EffectiveDate 1234567...C.....True.......1989-07-16...

>> AR Invoices and Cash Receipts Just a followup on an old thread637-1720718 I finally discovered a limitation in the ODBC driver being used. Documentation states.... limit of one left outer join per query. Once I realized this restriction I was able to get the results I needed. Now use...

Hi, I am looking for help in duplicating these values: - "Invoice total" and "Balance" --- for invoice Types CM (and DM). ----- as displayed on the "A/R Invoice History tracker". I've been using the formula below -- it appears to be working OK for type "IN" invoices. --- But I just noticed...

Hi, I'm looking for any suggestions/ideas for allowing MS SQL ODBC access for a limited number of users. This is an new issue since we've recently upgraded our ERP application AND migrated it to a hosted site. As far as I can tell, we're their first client to ask for ODBC and we're not making...

Thanks for the example. I'll test this as soon as (if) I get back to my office .......flights grounded yesterday due to the severe weather on the east coast. .............still stuck at the airport ................. a few more hours & I should finally be out of here. If your in the U.S. I...

Hi, I need a running count of one field AND reset on the change of anther field. Examples below of current output and desired output. My current query returns about 1700 records. The columns/data looks like this: JOB:............Part:.....Level:.....Seq 123:............3659........0.........3...

>>this is not specifically an Excel question, but a query SQL code question. Noted, one of those days... I just happened to be in Excel while looking at the select statements. >>Description field might be, is not a particularly reliable choice to make. Correct, this is a legacy convention on a...

Thanks, You are correct, now I see there are descriptions that begin with YY. Since I don't use Excel that much, I guess I was overthinking. Bruce O

Hi, Anybody know what yy% could be in Excel? Here it is in context: SELECT Part.Description FROM Part WHERE Description Not Like 'yy%' Thanks in advance for any help/insight. Bordway FWI... Reason... I'm converting old Excel spreadsheets that connect to an ERP system via ODBC. Upgraded to...

Nice to have something different to try. I've been sitting on a couple of these & I'm ready to get them out of my queue. Will report the results. Thanks Bruce O