can't save query (1 Viewer)

[weeboll]

SELECT [fiftykLabel] as section FROM
(SELECT a.section_label as fiftykLabel, b.section_label as twofivekLabel from [dsw 50k ends] as a left join [dsw 2500 ends] as b on a.section_label= b.section_label) where [twofivekLabel] is null


every time i try to save this query access closes with an error, yet the query runs ok

Any help much appriciated

Ta

WB

 

[namliam]

A wild gamble....

SELECT [fiftykLabel] as section FROM
(SELECT a.section_label as fiftykLabel, b.section_label as twofivekLabel from [dsw 50k ends] as a left join [dsw 2500 ends] as b on a.section_label= b.section_label) SomeName where [twofivekLabel] is null

Try that....

 

[weeboll]

nope unfortunatly no change. saving the query causings access to crash.

As the original query appears to run fine , could it be problem in the program rather than the sql?

 

[a.sinatra]

Try this:

SELECT [fiftykLabel] AS [section]
FROM [SELECT a.section_label as fiftykLabel, b.section_label as twofivekLabel from [dsw 50k ends] as a left join [dsw 2500 ends] as b on a.section_label= b.section_label]. AS [%$##@_Alias]
WHERE [twofivekLabel] is null;

________
Chevrolet Beretta Specifications

 

[weeboll]

hmm, originally once i'd run my query it put a very similar AS [^%"£!$&%!"£*_Alias] at the end which I removed. ever since access has been fubared and never added it back after run, but then again trying the same on another machine and database causes the same problems.

unfortunatly still no joy, hopefully the weekend will magically resolve all, if not further suggestions welcomed!

WB

 

[Kodo]

have you tried a compact and repair.. ?

 

[weeboll]

have you tried a compact and repair.. ?

many times!