Search results for query: *

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

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

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