Agree about Welsh's comments on DLOOKUP......

have you tried "Refresh" or "Requery"....either on the textbox or the parent form?...after your code

What version of Progress ?

Have you got the relevant Progress ODBC driver for your version?

Are you just looking at extracting the data from Progress...or sometning else?

How many tables/size/rowcounts etc.

Generally speaking,...

Plus 1....and forgive me for adding one word.....

[/quote]

here is an example using 'FOR XML PATH'

-- create some data

with produce (id,fruit, varieties)

as (

SELECT 101,'Apple', '3' UNION ALL

SELECT 101,'Banana', '2' UNION ALL

SELECT 102,'Orange', '1' UNION ALL

SELECT...

frdrckmitchell7 (11/28/2011)

---

It's rather a simple question: I have a table with 25 rows being displayed vertically and I want to display it next to each other in rows of...

....looking at whatt has been provided by the OP, I have a suspicion that the requirement is to maybe concatenate rows based on

RN 1 + RN 5 + RN 9....

RN...

Lynn Pettis (11/23/2011)

---

Actually, I think this is what is needed:

select Contract,...

does this help you....

SELECT Contract, Client, COUNT(*) AS ContractCount

FROM tbl_temp

GROUP BY Contract, Client

HAVING (COUNT(*) > 1)

Hi

I am trying to understand the business logic that allows you to have a single contract number with two versions that appear to be assigned to different Clients.....??

krypto69 (11/22/2011)

---

to match up with an excel spreadsheet showing us the data translations.

Long story but we are using a query to populate a table then doing a data dump from...

Please confirm how you are perfoming "script as...

Ninja's_RGR'us (11/18/2011)

---

Add that info into your calendar table. (like an Id for the period).

Then you can either join to it or prepopulate the variables using that id to navigate...

will you only ever have 4 columns?

what happens when you have more than 4 rows?

Charmer...pls post as asked above

based on what you posted...what results do you expect.