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 derfloh 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. jlbartley

    Outlook Schedule email to send later

    Does anyone know if Outlook 2003 has the ability to set an email to send at a later date?
  2. jlbartley

    Problem with Autonumber in append query

    Thank you for the post. Could you help me out a little bit more with the sql. Right now I have INSERT INTO FixedFields (OrigYear, Mid, Specdetail) SELECT FixedFields.OrigYear, FixedFields.Mid, FixedFields.Specdetail, Sum(VarFields.[4DWFTE] FROM FixedFields INNER JOIN VarFields ON...
  3. jlbartley

    Problem with Autonumber in append query

    I have two tables: FixedFields: ID (AutoNumber), OrigYear, Mid, Specdetail VarFields: ID (joined to FixedFields.ID), RecordType, PlanYear, 4DWFTE) I want to append records into both tables, grouping by ID where sum(VarFields.4DWFTW)<>0 and VarFields.PlanYear = 2001. How do I do an append query...
  4. jlbartley

    Append query insert into multiple tables

    I'm trying to create an append query that will append information from two different tables into two different tables. I don't know VBA so would like to do this by just using sql. I could do this with two seperate sql statements but would prefer to do it in one if possible. Any ideas? Thanks!
  5. jlbartley

    Append query with autonumber

    I have a table called FixedFields. I need to append rows from that table onto the end of the table. For example: Table: FixedFields Fields: InitiativeNo (autonumber),Site, OrigYear, How do I append these records and have the InitiativeNo select the next autonumber in the sequence? The way I...
  6. jlbartley

    Need help ASAP-update query with sum

    Thank you so much! This worked out great. It was exactly what I was looking for!
  7. jlbartley

    Need help ASAP-update query with sum

    I posted this earlier and never got an answer so I thought I would try again. I've got one table called VarFields that has fields called InitiativeNo, PlanYear, and 4DWFTE. I want to update all of the PlanYear from 2001 to 2002 where the sum(4DWFTE) <> 0. When I try this it says that I...
  8. jlbartley

    Sum in an Update Query

    I have one table that I am trying to update information in. You're right that I had the FixedFields table linked and didn't need to. I have one table called VarFields that contains fields named InitiativeNo, PlanYear, 4DWFTE, etc. I am trying to update all of the PlanYears to 2002 where the...
  9. jlbartley

    Sum in an Update Query

    I am trying to do an update query and having problems. It seems pretty simple but I'm obviously missing something. I have two fields in the query, one is the year and the other is a number. I need the query to update the year to 2002 where year = 2001 and sum(number) <>0. However, it won't...

Part and Inventory Search

Back
Top