IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Theory and Practice of Programming Forum / Re: Another MS Access Question
Post #319,244
by pwhysall
Picture of pwhysall
12/29/09 3:30:39 AM
Reply
New Re: Another MS Access Question
Can't you just drag the columns around in the query editor?
Post #319,250
by jbrabeck
12/29/09 5:20:11 AM
Reply
New I have dragged to columns around
SELECT DISTINCT JCLPRC.Member, JCLDSN.DSN, JCLPRC.Step, JCLDSN.DISP, JCLDSN.LRECL

The SELECT statement shows the order that the query columns are in. Member, DSN, Step, DISP, and then LRECL.

The output is being sequenced by the table, then column. Member, Step, DSN, DISP, LRECL.

I've tried leaving the table unsorted, various output orders, even dropping the member column. Then the output is Step, DSN, DISP, LRECL.

The query WAS working correctly. I have no control over the version of Windows, nor Office, nor Access. Corporate does remote upgrades.
Post #319,252
by pwhysall
Picture of pwhysall
12/29/09 5:41:46 AM
Reply
New How peculiar.
Has anything changed? Version of Access? Has anyone compacted/repaired the database?
Post #319,253
by jbrabeck
12/29/09 5:46:47 AM
Reply
New I am the "DBA"
Since I am working with mainframers, they have no idea of how Access works. I have not compacted the database since the last time I refreshed the tables (Nov 1st). Version of Access is something that I have no control over. Updates and "patches" are applied remotely overnight, whenever corporate deems necessary.

If you think it would help, I can always try to "repair" and "compress" the database. I usually get in before anyone starts using the app.
Post #319,254
by pwhysall
Picture of pwhysall
12/29/09 5:49:25 AM
Reply
New I'm clutching at straws, TBH
But has the version changed? This may explain your situation, even if it does not offer a solution.
Post #319,255
by jbrabeck
12/29/09 5:58:30 AM
Reply
New I understand...
the clutching at straws. To make matters "worse", it happened before. I don't remember if it was this query or another query. Anyway, I deleted the query and recreated it, and the problem "went away", until now.

Since I don't have any control of the versions, I don't know what I was running, nor what I am running. iow, I have no way of knowing if/when I get new upgrades.

Post #319,259
by pwhysall
Picture of pwhysall
12/29/09 8:36:24 AM
Reply
New Time to put a report in the way, I think
At least that way you'll have control over the column order.
     Another MS Access Question - (jbrabeck) - (16) - Dec. 28, 2009, 08:16:56 PM EST
         Why does the column order matter? - (static) - (5) - Dec. 28, 2009, 08:44:52 PM EST
             Output is used for other documents - (jbrabeck) - (4) - Dec. 29, 2009, 05:26:29 AM EST
                 Ouch. - (static) - (3) - Dec. 29, 2009, 07:38:09 AM EST
                     Wish I could ditch Access - (jbrabeck) - (2) - Dec. 29, 2009, 09:06:09 AM EST
                         Harder? - (crazy) - (1) - Dec. 30, 2009, 09:54:24 AM EST
                             Well... - (folkert) - Dec. 30, 2009, 02:52:12 PM EST
         Re: Another MS Access Question - (pwhysall) - (6) - Dec. 29, 2009, 03:30:39 AM EST
             I have dragged to columns around - (jbrabeck) - (5) - Dec. 29, 2009, 05:20:11 AM EST
                 How peculiar. - (pwhysall) - (4) - Dec. 29, 2009, 05:41:46 AM EST
                     I am the "DBA" - (jbrabeck) - (3) - Dec. 29, 2009, 05:46:47 AM EST
                         I'm clutching at straws, TBH - (pwhysall) - (2) - Dec. 29, 2009, 05:49:25 AM EST
                             I understand... - (jbrabeck) - (1) - Dec. 29, 2009, 05:58:30 AM EST
                                 Time to put a report in the way, I think - (pwhysall) - Dec. 29, 2009, 08:36:24 AM EST
         Ok, now I REALLY cornfuzed - (jbrabeck) - (1) - Dec. 29, 2009, 09:01:37 AM EST
             Possible theory... - (Mycroft_Holmes_Iv) - Dec. 29, 2009, 11:04:08 PM EST
         Are the tables linked from elsewhere? - (scoenye) - Dec. 30, 2009, 07:28:43 PM EST

Brought to you by the Tennessee Valley Authority!
47 ms