Freshman
Registered User.
- Local time
- Today, 09:37
- Joined
- May 21, 2010
- Messages
- 437
Hi all,
I've seen the answer to my question on a few places but just can't seem to implement it on mine. Maybe I'm missing something when changing their fields to mine, so I'll give my table and field names if someone can help please
Table: Career
Fields:
CareerID AutoNum and PK
ID Num (relationship to main table not relevant now)
SinceDate Date in question
MrkC Flag
I need to set the MrkC flag to -1 for the Max 'SinceDate' of each 'ID' row
I keep getting a not-updatable query error
Thanks a lot
I've seen the answer to my question on a few places but just can't seem to implement it on mine. Maybe I'm missing something when changing their fields to mine, so I'll give my table and field names if someone can help please
Table: Career
Fields:
CareerID AutoNum and PK
ID Num (relationship to main table not relevant now)
SinceDate Date in question
MrkC Flag
I need to set the MrkC flag to -1 for the Max 'SinceDate' of each 'ID' row
I keep getting a not-updatable query error
Thanks a lot