You are reading a single comment by @rhb and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
cyberyark
@rhb
MS Access (I know) headache:
Got data on an old s.sheet but queries and updates working easier on db so I built a basic one around the table.
When importing the field "Age" it was a value not calculated based on dob, so remains static not current.
Trying to fix this using =datediff ('yyyy', [DOB],Date ()) via an append query for a new 'Age' column (deleted original as no value, but could re-import easily).
Error is about validation rules, when there are none in the db as nothing is that complex. Preview view works perfect in that it shows a year value based on each DOB in the table... Some rows blank as no DOB.
Anyone used this similarly and got it working? Cheers.
P.s. used same expression in regular query to export data as part of export to load data to email campaign sender, it works fine for that... (although rounds up some ages but hey, what difference does a year make?)