Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is There a way To +1 in Every Row In A Query

Status
Not open for further replies.

NewYorkFashionToGo

Programmer
Oct 20, 2006
44
US
I am in process of Building an xml feed to feed into endicia for shipping. I tried exporting a file in XML format, It is very close to what I need, But not 100% what I need. I am trying to do some data manipulation in a query and I am stuck.

A small example of what the final result should be is:

<Package ID="1"> Need to manipulate
<MailClass> Perfectly fine
<Flat Rate> Perfectly fine
<More Fine> Other Fine fields
<Even More Fine> Other Fine Fields
<Package ID="2"> Need To Manipulate


I am running a query In one Field That will be hidden I want to put ="<Package ID="

In A completely seperate Field I want The Number Starting at 1 and adding 1 down each row in that column so It would be 1 , 2, 3, 4
Then In the third Hidden field I want to close it With ="">"
Then In the fourth Field I want to Put the other textfrom the three columns together So It will read in the query as: and The other fields.
<Package ID="1">
<Package ID="2">
<Package ID="3">


I am also open to any other suggestions I have about achieving doing shipping through endicia, Doesnt have to be this way. Just to mabee give me a different angle of looking at the problem in front of me.

Thanks In advance (o;

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top