Query in SQL view. How to save the formatting/layout?

[Chatbox]

Everytime after I save a query, all the layout/formatting is lost. And the next time I open a query in SQL view, it's all sqeezed together again. I don't like that. It's not easy to read.

Can anyone help?

 

[Chatbox]

hum....it doesn't seem to do that

I want it from this:

SELECT dbo_QuotedAirRates.QuoteID, ('Min: ' & formatcurrency(IIf(isnull(dbo_QuotedAirRates.CustMinimum),dbo_QuotedAirRates.Minimum,dbo_QuotedAirRates.CustMinimum))) AS Minimum, ('Less than 500: ' & formatcurrency(IIf(isnull(dbo_QuotedAirRates.custlt500),dbo_QuotedAirRates.lt500,dbo_QuotedAirRates.custlt500))) AS lt500, ('More than 500: ' & formatcurrency(IIf(isnull(dbo_QuotedAirRates.custmt500),dbo_QuotedAirRates.mt500,dbo_QuotedAirRates.custmt500))) AS mt500, ('More than 1000: ' & formatcurrency(IIf(isnull(dbo_QuotedAirRates.custmt1000),dbo_QuotedAirRates.mt1000,dbo_QuotedAirRates.custmt1000))) AS mt1000, dbo_QuotedAirRates.SubQuoteID, (dbo_QuotedAirRates.OrgAirport+', '+dbo_QuotedAirRates.OrgCountry+' ('+dbo_QuotedAirRates.OrgIATACode+')') AS Origin, (dbo_QuotedAirRates.DstAirport+','+dbo_QuotedAirRates.DstCountry+' ('+dbo_QuotedAirRates.DstIATACode+')') AS Destination, dbo_QuotedAirRates.Hub, dbo_QuotedAirRates.Cur, dbo_QuotedAirRates.TransitTime, dbo_QuotedAirRates.Effective, dbo_QuotedAirRates.FSC, dbo_QuotedAirRates.SSC, dbo_QuotedAirRates.HandlingFee, dbo_QuotedAirRates.Remarks, dbo_QuotedAirRates.Region
FROM dbo_QuotedAirRates
WHERE (((dbo_QuotedAirRates.QuoteID)=[QuoteID]));

To this:

SELECT dbo_QuotedAirRates.QuoteID,
('Min: ' & formatcurrency(IIf(isnull(dbo_QuotedAirRates.CustMinimum),dbo_QuotedAirRates.Minimum,dbo_QuotedAirRates.CustMinimum))) AS Minimum,
('Less than 500: ' & formatcurrency(IIf(isnull(dbo_QuotedAirRates.custlt500),dbo_QuotedAirRates.lt500,dbo_QuotedAirRates.custlt500))) AS lt500,
('More than 500: ' & formatcurrency(IIf(isnull(dbo_QuotedAirRates.custmt500),dbo_QuotedAirRates.mt500,dbo_QuotedAirRates.custmt500))) AS mt500,
('More than 1000: ' & formatcurrency(IIf(isnull(dbo_QuotedAirRates.custmt1000),dbo_QuotedAirRates.mt1000,dbo_QuotedAirRates.custmt1000))) AS mt1000,
dbo_QuotedAirRates.SubQuoteID, (dbo_QuotedAirRates.OrgAirport+', '+dbo_QuotedAirRates.OrgCountry+' ('+dbo_QuotedAirRates.OrgIATACode+')') AS Origin,
(dbo_QuotedAirRates.DstAirport+','+dbo_QuotedAirRates.DstCountry+' ('+dbo_QuotedAirRates.DstIATACode+')') AS Destination,
dbo_QuotedAirRates.Hub,
dbo_QuotedAirRates.Cur,
dbo_QuotedAirRates.TransitTime,
dbo_QuotedAirRates.Effective,
dbo_QuotedAirRates.FSC,
dbo_QuotedAirRates.SSC,
dbo_QuotedAirRates.HandlingFee,
dbo_QuotedAirRates.Remarks,
dbo_QuotedAirRates.Region
FROM dbo_QuotedAirRates
WHERE (((dbo_QuotedAirRates.QuoteID)=[QuoteID]));

Everytime I save and reload in SQLView, it loads up as it was in the first example.

 

[llkhoutx]

Is Access security in effect and if so, do yuo have rights to save queries? Just a thought.