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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.