I have a table in Oracle that contains following:
Order #, Customer#, Raw#
123, 2456, 1
354, 2456, 2
657, 2489, 3
858, 2447, 4
955, 2489, 5
I would like to get the results from the table that will look like this:
2456, 123, 354
2489, 657, 955
2447, 858
Any help would be appreciated.
mamin
Joined: Apr 5 '07
Location:
-
Thank you. It worked but the only thing I do not want is quotes around each text field.... -
mamin started a topic Exporting MS Access table to text file and appending current date to file name.in AccessExporting MS Access table to text file and appending current date to file name.
I have a table that I need to export out to a text fiel, without column headers. I also need to have the file name include currernt date. Can anyone help me? I'm using the following code:
[B]Public Function CreateFiles()
Dim db As Database
Dim rst As Recordset
Dim m_str As String
Dim dt_str As String
Dim y_str As String
Dim d As Variant
Dim dir_str As String
... -
Thank you. I will try that....Leave a comment:
-
Performing calculation using two rows from the same table
I have a table that contains file name, file seq num, etc. I would like to compare the two rows to make sure the file seq num is being incremented by one or more. If it is incremented >1 then I l know that there is a file missing.
No activity results to display
Leave a comment: