Query Problem

[Bryan Hughes]

Hello,

I am trying to create a append query, but having trouble figuring it out.

I have two tables I am working with, one is a main and the other is a sub
table.

I need to get the last date ([Activity]![CAD]) and activity status
([Activity]![CAS]) As LastCAS entered for a ID Number ([Activity]![GTFID]).

Then if the ID Number [Main]![GTFID] is still open [Main]![Open] in the Main
table get the Date opened [Main]![IOD] ,
add Current month and year to [Main]![IOD] (CDate(Month(Date()) & "/" &
DatePart("d", [Main]![IOD]) & "/" & Year(Date())) As NewCAD)

then append the [GTFID], NewCAD, LastCAS to the Activity table.

-TFTH
Bryan

 

[Michel Walsh]

Hi,


Have you took a look at http://www.mvps.org/access/queries/qry0020.htm ?


Hoping it may help,
Vanderghast, Access MVP