Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Query: Use value of field as anothers criteria


    I am writing a query and I need to use one of the fields as the criteria. So its like

    SELECT a.field1, a.field2, b.field1, b.field2 FROM a, b WHERE b.field1 LIKE a.field1

    See, I need to only retrieve those values for when b.field1 is like a.field1. The problem is that the one field is a web address (http://www....) and the other the end part of the url (how_to_create_order.html). So, a link is not possible (right?). I can compare the two with strings and * but I need a query to be able to this for many records.

    I use the Design View for queres. Here's a SQL that not working.:
    SELECT Table.Field1, Table.Field2, Table.Field3, Table.Field4, Table.Field5, Table.Field6, fs.Filename
    FROM [Table], fs
    WHERE (((fs.Filename) Like "*[Table]![Field6]*"));

    Any suggestions?

    Thanks in advance

  2. #2
    Join Date
    Jan 2004

Posting Permissions

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