Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: troyster
  • Content: Threads
  • Order by date
  1. troyster

    SQL code to input data in field based on data from another table

    We have a need to place a character "X" in a field of a relationshiped table based on a field in another table being "not null", this is to occur for several fields and to be updated upon command. We are using Access 2002, what would be the SQL code for something like this?
  2. troyster

    populate a field in a database from data filter from another database

    I need to populate a field in another table based on data matching a filter in my prime database, i.e. place an "X" in tblITR_Instrument.E01 for tblInstrument.instrument=”Y”. The tables have a relationship field, this is to show whether or not an action is needed to be done. I have...
  3. troyster

    populate field based on selected data in another table

    I need to populate a field in another table based on data matching a filter in my prime database, i.e. place an "X" in tbl "B", Field Q for "*XYZ*" in tbl "A", Field "Z". Is this a possibility? I appreciate any assistance in this matter.

Part and Inventory Search

Back
Top