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 Mike Lewis 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. g33kgrrl

    specified field could refer to more than one table listed...

    I ended up renaming (with an alias) the offending colmn in both of the queries and it worked. How stupid. Gawd -I love programming some days......
  2. g33kgrrl

    specified field could refer to more than one table listed...

    I have a query named qry_scorecard that joins a table and another qry - it runs fine. (I have scoured the SQL and it does not have duplicate field names.) My second query (qry_scorecard_TEMP) retrives data from the original qry_scorecard. It is the only table or query being accessed. I keep...
  3. g33kgrrl

    supress a detail row of data

    Hi - I have a row of detail data that has 5 fields of data. I want to not repeat the row if fields 1-4 are identical. Should I use the 'previous' and check each field in a nested if? And then, if they are all identical- supress the row? There is probably a VERY easy solution which I am...
  4. g33kgrrl

    Date Formula.

    Yep - I was using Oracle and this worked perfect. Thanks so much!!
  5. g33kgrrl

    Date Formula.

    I know this should be easy, but I must be brain-dead today. I need to find all of my employees who are at least 70 years old as of 6/1/2007. This is the formula I am using in my selection criteria: {PAEMPLOYEE.BIRTHDATE} < {?effective date} - 70 It is not working. Thanks for your help.

Part and Inventory Search

Back
Top