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?

 

[Uncle Gizmo]

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?

If you Alter the query layout and press the save button, it saves the changes you make.

 

[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.

 

[Uncle Gizmo]

I open a query in SQL view, it's all sqeezed together again

Oh! I thought you were talking about the view of the query, but you actually mean the SQL behind the query don't you.

Well that's what the query designers for, that shows you a nice view of your query. I'm afraid you have no control over the formatting in the SQL view.