Recent content by jlbartley

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

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

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

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!

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

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

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

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

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