Query Headings

[EscapeUK]

I have a queryDef that calls a stored procedure.

However I would like to code the query headings myself

 

[DougP]

What are you actually doing in the Stored Procedure???
Creating a table?????

In Access you would use
Custname:[YourCustomersFieldname]
which would make the column heading or title "Custname"

in SQL use
Select YourCustomersFieldname AS Custname, someother columns Where ....


so the AS clause creates an expression which will show up
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[EscapeUK]

No just searching a table the As thing does not seem to work.

Can you see anything wrong with this

CREATE PROCEDURE sp_mysp
@Var1 varchar(100),
@Var2 varchar(100)

AS

select ABC_Table1.Description, ABC_Table2.Description


from ABC_Anothertable
JOIN ABC_Table1 ON (ABC_Table1.ID = ABC_AnotherTable.ref)
JOIN ABC_Table2 ON (ABC_Table2.ID = ABC_AnotherTable.Ref2)

Where ABC_AnotherTable.ref = @Var1 And ABC_AnotherTable.ref2= @Var2

 

[EscapeUK]

its ok i feixed it

here is my alteration if anyone is interested

select ABC_Table1.Description As [Title1], ABC_Table2.Description AS [Title2]