You are reading a single comment by @Chalfie 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.
@Chalfie
Data comes from select survey in a wide format.
Current year has 2600 lines.
Survey is added to weekly from which ever schools have notifications to tell me.
Archive has 1755 lines.
I am trying to get things in place for if/when I leave. I want it to be simple and easy to understand.
extract data as csv.
open access. update linked table. run query to append / add to archive.
save as a linked table.
open excel
win