How to take the results of query and copy them to a column in a table?
I am using sharepoint and ms access together, and Sharpoint in this instance will not reference the result of the query. I can only use table fields with Sharepoint...major pain....
Example, I need riders name, weight and height from the column in ALL INfo query to automatically fill the column table in ALL Info
anyone have an example of how to do this?
maybe something like
queryreservations!AllINfo.value=tablereservations!Allinfo.value
and how to loop through records that are not filled out already?
seems like it should be a simple Do.command but I am not sure how to code it
(....Yes I understand that is not ideal database design to do this but sharepoint is forcing the issue....please help this will make it soooo much easier to have riders weight, hieght on our calendar view without having to get their information typed in twice...once on the contacts sharepoint table and once on the reservations table....and no, I am using ms office 365 sharepoint so there is no way to go back and create contact IDs that link to each contactID. reservation sharepoint table....) without doing days of work...and having to redo everyones link to the current calendar view.....)
I am using sharepoint and ms access together, and Sharpoint in this instance will not reference the result of the query. I can only use table fields with Sharepoint...major pain....
Example, I need riders name, weight and height from the column in ALL INfo query to automatically fill the column table in ALL Info
anyone have an example of how to do this?
maybe something like
queryreservations!AllINfo.value=tablereservations!Allinfo.value
and how to loop through records that are not filled out already?
seems like it should be a simple Do.command but I am not sure how to code it
(....Yes I understand that is not ideal database design to do this but sharepoint is forcing the issue....please help this will make it soooo much easier to have riders weight, hieght on our calendar view without having to get their information typed in twice...once on the contacts sharepoint table and once on the reservations table....and no, I am using ms office 365 sharepoint so there is no way to go back and create contact IDs that link to each contactID. reservation sharepoint table....) without doing days of work...and having to redo everyones link to the current calendar view.....)
Last edited:
