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 wOOdy-Soft 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: *

  1. russanalyst

    Changing a " " value to a blank - !!

    Hi. This might sound stupid but it is a real issue for us. In our datafile some fields' values were updated to " " . A government entity wants the value to be blank, instead. How do I change this? Likewise, there are some instances where the reverse is true. How do I change those? Russ
  2. russanalyst

    avoiding multiple repetitive input

    Hi. I have numerous queries each based on a different table. With the same parameter, although each table has difefernt fields. Currently the user has to enter the parameter multiple times. I do NOT need the user to modify, add, or change adta. Simply to see existing data. How? Please be...
  3. russanalyst

    'unique' filter question

    Hi. I inherited some un-normalized tables and need some help. I have 20 tables each with an ID field and a dozen text fields, each containing unique values. I need the user to be able to enter the requested ID and the requested value which could exist in any of the fields in any of the tables...
  4. russanalyst

    Limiting fields in report - but unique situation

    Hi. I have a query which looks in a table having 13 fileds. One field is a client ID, the others contain text. I need to have the user enter the ID and then the value that they seek in a given field. And, have only the ID and that one field with that specific value show. I made a query with...
  5. russanalyst

    convert numbers to text

    Hi. How do I convert number fields (double with 2 decimal places and with data) to text fields maintaining the actual numbers after the decimal point. Please be specific. Thanks! Russ
  6. russanalyst

    convert currency field data to text keeping decimal points

    Hi. I really need to convert fields with currency data into text values AND still keep the decimal point and the numbers after it. Russ
  7. russanalyst

    adding specific text string to existing field value , data

    Hi. I believe that I have found a way to solve a problem in a much faster manner than I thought possible. But I need some coding help. I have a table with a field called 4/2006 which contains a text string of numbers. How can I code a query that will add '4/2006 -' to each record's 4/2006...
  8. russanalyst

    copied a form in same database, but cannot tab past 1st field

    Hi. I have a form that I needed to duplicate except for a few field changes. If I want to edit an existing record, no problem. But if making a new record or changing the existing record's 1st field, I cannot tab out the field. (It is an idnumber, primary key field). Ideas??????? Russ

Part and Inventory Search

Back
Top