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!

Recent content by g33kgrrl

  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.
See more

Part and Inventory Search

Back
Top