Search
Search titles only
By:
Search titles only
By:
Home
Forums
What's new
Members
New posts
Search forums
VIP
OSA Radio
Chat
0
Features
Tunes
Mixes
Events
Flyers
Forums
Log in
Register
Search
Search titles only
By:
Search titles only
By:
What's new
Members
New posts
Search forums
Menu
Install the app
Install
Reply to thread
Welcome to Old Skool Anthems
The Old Skool Resource. Since 1998.
Join now
NATIVE INTERNET WEB RADIO PLAYER PLUGIN FOR SHOUTCAST, ICECAST AND RADIONOMY
powered by
Sodah Webdesign Mainz
Forums
Updates & Help
Help
anyone know microsoft access?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="Danny" data-source="post: 301438" data-attributes="member: 537"><p>i'm currently undertaking a series of town population studies in the UK. i have all the data now sorted into seperate excel files, and also have jpeg map images of each of the population areas i have coverered ..... but instead of the client having to open each file individually and then match the map image with the are i would like to build a database where as to the image will be shown alongside the data ..... it shouldnt be too difficult, but i'm not too fluent with access yet ..... can anybody offer us any pointers? cheers in advance <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /> </p><p></p><p>examples of the data i want to be shown next to each other are ahown below. i presume i can simply copy and paste the excel data into a database, but dont know how to go about getting the relative maps to appear next to the data. </p><p></p><p>Danny <img src="/styles/default/xenforo/smilies/classics/crazy.gif" class="smilie" loading="lazy" alt=":crazy:" title="acrazy :crazy:" data-shortname=":crazy:" /> </p><p></p><p>WEST LOTHIAN COUNCIL AREA </p><p></p><p>ALL PEOPLE AREA (HECTARES) Density (number of persons per hectare) </p><p></p><p>SUMMARY 158714 42860.74 3.7 </p><p>Almond 4787 1290.27 3.71 </p><p>Armadale Central 4455 433.62 10.27 </p><p>Armadale West 4966 2244.91 2.21 </p><p>Blackburn 5192 2243.52 2.31 </p><p>Boghall 4287 111.66 38.39 </p><p>Breich Valley 5273 6148.47 0.86 </p><p>Calderwood 5094 1131.4 4.5 </p><p>Carmondean 5504 114.43 48.1 </p><p>Craigshill 4628 332.97 13.9 </p><p>Croftmalloch 4633 118.2 39.2 </p><p>Deans 5425 315.93 17.17 </p><p>Dedridge 5405 120.3 44.93 </p><p>Durhamtoun 3861 1048.88 3.68 </p><p>East Calder 4999 244.37 20.46 </p><p>Easton 4675 194.96 23.98 </p><p>Fauldhouse 5154 2209.8 2.33 </p><p>Houstoun 4704 520.7 9.03 </p><p>Howden 5515 302.98 18.2 </p><p>Kingsfield 5630 3432.22 1.64 </p><p>Kirkton 4987 327.09 15.25 </p><p>Knightsridge 5728 381.37 15.02 </p><p>Ladywell 4893 135.78 36.04 </p><p>Limefield 4752 387 12.28 </p><p>Linhouse 5118 6945.62 0.74 </p><p>Middleton 4729 177.81 26.6 </p><p>Murieston 5174 784.81 6.59 </p><p>Newland 4478 739.81 6.05 </p><p>Oatridge 4782 2530.38 1.89 </p><p>Polkemmet 4584 1809.83 2.53 </p><p>Preston 5902 5307.26 1.11 </p><p>St Michael's 4818 527.5 9.13 </p><p>Strathbrock 4582 246.89 18.56</p></blockquote><p></p>
[QUOTE="Danny, post: 301438, member: 537"] i'm currently undertaking a series of town population studies in the UK. i have all the data now sorted into seperate excel files, and also have jpeg map images of each of the population areas i have coverered ..... but instead of the client having to open each file individually and then match the map image with the are i would like to build a database where as to the image will be shown alongside the data ..... it shouldnt be too difficult, but i'm not too fluent with access yet ..... can anybody offer us any pointers? cheers in advance :) examples of the data i want to be shown next to each other are ahown below. i presume i can simply copy and paste the excel data into a database, but dont know how to go about getting the relative maps to appear next to the data. Danny :crazy: WEST LOTHIAN COUNCIL AREA ALL PEOPLE AREA (HECTARES) Density (number of persons per hectare) SUMMARY 158714 42860.74 3.7 Almond 4787 1290.27 3.71 Armadale Central 4455 433.62 10.27 Armadale West 4966 2244.91 2.21 Blackburn 5192 2243.52 2.31 Boghall 4287 111.66 38.39 Breich Valley 5273 6148.47 0.86 Calderwood 5094 1131.4 4.5 Carmondean 5504 114.43 48.1 Craigshill 4628 332.97 13.9 Croftmalloch 4633 118.2 39.2 Deans 5425 315.93 17.17 Dedridge 5405 120.3 44.93 Durhamtoun 3861 1048.88 3.68 East Calder 4999 244.37 20.46 Easton 4675 194.96 23.98 Fauldhouse 5154 2209.8 2.33 Houstoun 4704 520.7 9.03 Howden 5515 302.98 18.2 Kingsfield 5630 3432.22 1.64 Kirkton 4987 327.09 15.25 Knightsridge 5728 381.37 15.02 Ladywell 4893 135.78 36.04 Limefield 4752 387 12.28 Linhouse 5118 6945.62 0.74 Middleton 4729 177.81 26.6 Murieston 5174 784.81 6.59 Newland 4478 739.81 6.05 Oatridge 4782 2530.38 1.89 Polkemmet 4584 1809.83 2.53 Preston 5902 5307.26 1.11 St Michael's 4818 527.5 9.13 Strathbrock 4582 246.89 18.56 [/QUOTE]
Verification
Post reply
Forums
Updates & Help
Help
anyone know microsoft access?
Top
Bottom
