Access 2000 Query Question

Results 1 to 2 of 2

Thread: Access 2000 Query Question

  1. #1
    Join Date
    Dec 1969

    Default Access 2000 Query Question

    I&#039;ve built a query inside of Access which retrieves certain records I want. I was able to call it from my asp page using...<BR><BR>SQL = "Select * FROM CharactersList"<BR><BR>However, can I set the query up so that it will dynamically display results based on a value I send with the above query? Like the way you do with Stored Procedures in SQL Server.<BR><BR>SQL = "sp_CharactersList &#039;" & value & "&#039;"<BR><BR>I rarely ever use Access, so I&#039;ve never tried this before. I&#039;m not sure how to send it to the database or even how to use it in the query, once it&#039;s got it. Or wheteher this is even possible??<BR><BR>Thanks,<BR>Wil<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Access 2000 Query Question

    easiest way:<BR><BR>SQL = "SELECT * FROM CharacterList WHERE Character = &#039;" & value "&#039;"<BR><BR>or create a stored query with a parameter, you can execute it the same as a stored proc<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts