Query Question

Results 1 to 2 of 2

Thread: Query Question

  1. #1
    Join Date
    Dec 1969

    Default Query Question

    I have a query which calls a function to calculate a value. I would like to sort on that calulcated value but when I sort that record set I get an error. The error asks for the values in my calculated field.<BR><BR>My solution was to create a second query that simply sorts that calculated field. <BR><BR>My problem is that one of the fields in the original query is used as a filter that the user enters from the ASP page. So I need to run the second query from the ASP page at the same time add the filter from the ASP page to the first Query.<BR><BR>Thanks for any help,<BR><BR>MTmace

  2. #2
    Join Date
    Dec 1969

    Default I need more info...

    can you paste some of the code?<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