Help to a query

Hi

In acces i use this:

[varebetegnelse] & " Med ordennummer:--" & [ordenummer] AS tekst

Where [varebetegnelse] and [ordennummer] is column in my query

How can i do this in a view in SQL ?

Second
also in acces i use a criteria based on a form like this

WHERE (((kategori.katId)=[Forms]![samlekursus]![kategorinr]))

How can i do this in a view in SQL

I work from access cnoocted to SQL sever

Regards

alvin

You will either have to do the filtering on the view (using the view as a mapped table and building a query in access on top of that)

Select SomeColumns
FROM
Viewname
WHERE (((kategori.katId)=[Forms]![samlekursus]![kategorinr]))

Or use a parametrized query, passing the parameter to the procedure.

EXEC SomeProcedure @.SomeVariablewithin = 'YourValue'

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de