Search results

  1. D

    Query keyword from table, need it to tag result with column keyword was in

    Ok, found out how to tag each record using a select query, just need to change it into an update query. If you want to see my sql to understand what i'm doing, here it is: SELECT [SAP-Dump].[Record#], [SAP-Dump].Description1, [SAP-Dump].Description2, [SAP-Dump].OtherStuff, [SAP-Dump].Blah...
  2. D

    Is there a way to put IIF statement criteria into a table?

    Found the answer to what you want, you can either have it be a select query, or turn it into an update query. Ironically you answered part of what I wanted, now I just need to figure out how to do some specifics. SELECT [SAP-Dump].[Record#], [SAP-Dump].Description1, [SAP-Dump].Description2...
  3. D

    Is there a way to put IIF statement criteria into a table?

    I've found how to search fields in a table, so without needing to make an if statement you can just create a list of what would fit into each category, but I don't know how to update a field based on which field it found the result in. In fact I have been trying to get help with the exact same...
  4. D

    Query keyword from table, need it to tag result with column keyword was in

    Thank you for the info of editing the forms code adding an on load function. The reason we would need to store the result is that sometimes it may not be accurate, and may need to be re-categorized. Categorizing based on keywords can sometimes include records that aren't what I want and I need...
  5. D

    Query keyword from table, need it to tag result with column keyword was in

    I currently have a record table, a lookup table, and an empty table. The query compares the records of the record table to the words in a field of the lookup table, if the record contains the words, it copies the record to the empty table. Because the empty table is an empty copy of the records...
  6. D

    Query keyword from table, need it to tag result with column keyword was in

    I like the buckaroo bonzai reference. Yeah, I'm probably breaking several good DB keeping rules, mainly because I'm trying to use the fields as records and I intentionally need to go around some restrictions because this db is only an extension of an SAP/oracle db, and I've gotten it to work...
  7. D

    Query keyword from table, need it to tag result with column keyword was in

    Keyword query, need it to create field in data table with field keyword was found in I've got 2 tables, one which has records in it, and I have a second table that has is only a lookup table and not conforming to good database practices with keywords in it. Each field on the lookup table is a...
Back
Top Bottom