Re: pass field or table names as parameter?

RB Smissaert wrote:
Is it possible to pass field or table names as parameters
to a query? So can you do:

select count(?) from ?

and then supply the field and table as a variant array?


No. This is one of the situations that requires dynamic sql
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Expression Builder
    ... Open the query in Design View. ... This is what the SQL statement shows: ... This email account is my spam trap so ...
    (microsoft.public.access.queries)
  • Re: Expression Builder
    ... Open the query in Design View. ... This is what the SQL statement shows: ... This email account is my spam trap so ...
    (microsoft.public.access.queries)
  • Re: Expression Builder
    ... Open the query in Design View. ... Could you show us the sql statement for your query? ... This email account is my spam trap so ...
    (microsoft.public.access.queries)
  • Re: ASP and Access SQL Problem
    ... > following in an asp page: ... > Dim objRS ... Your query does not return records - why open a recordset??? ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: Q
    ... > sorry for typo, only those whitch are not 1 ... The above query should work if you are using SQL Server, ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)