Search results

I will revise based on your comments. Thankyou.

i see its a many to many now after re-reading above. oops. ill add a junction table in. Majp. Do you have a sample kicking about or a link i could use to see how this would be achieved. I feel stupid now!:(

thanks for the replys. I will try to define it a little clearer. I work in a design office (architectural - timber frame) , we have specifications for each project which should be consistent and they are constantly inconsitant or even incomplete. Each project only has 1 specification but...

First post in a long time and im struggling to get my head back in to it. I think i am barking up the wrong tree. I have 2 tables. 1 simply contains project numbers the second contains specification elements and a yes no check box table The result i am trying to achieve is a check box form...

Hi All. :banghead: I am returning to access to try once more to sort out my life issues! I know thats a big ask lol. I started looking at access as a solution several years ago but didnt have the spare time needed to get everything working. I am a an architectural tech by day, from Scotland...

Hi. I am currently undertaking a massive project of getting our office paper free (as best we can) I have novice experience level so please be gentle. First thing I am doing is looking at the data I need and attempting to rationalize it. Where ai am looking for advice is the specification...

Ok I guess that this is not the right way to go about getting help. I think I better start a new thread with specific issues. For those that downloaded the database. any suggestions?

I am now at the extent of my knowledge on the database I am trying to do to manage my selfbuild house. Not sure which forum a post like this fits so the general one seemed best. I have created the attached so far. Please take a look. as it stands. I think it is nearly there in the...

Hi all. Relative newbie question For the purpose of this i will use an example. I have a table of values as follows. columns are value 1 | value 2 | Value 3 | Value 4 | I want to highlight the lowest value in each row using conditional formating or similar. i also want the lowest figure...

I am creating a database to help manage my self build house project. This is using access 2010 database The table that are concerned are materials merchants material prices I have a table of merchants with their contact details etc and another table The prices table has 4 fields id...

Please???? Need some help with this. cherry on top

This is a slight continuation of this post here, but this post inst really all that relevant unless you want to see the mess I have tided up... After a fair bit of trial and error I now think that I have followed normalization and binned the repeating data structures that I had before. I have...

Ok. Going on above i have further normalised my data structure which has simplified things immensely. As i am sure you would have expected. I know that this is the Queries subforum so I will make a new thread for my question here.

Would anyone be interested in advising on the database structure if I attached the database? Can I attach the database? It was based originally on a MS template file named tasks and is growing and getting quite messy. I have a format for the forms/sub-forms that works at the moment and allows...

Hi. thanks for the reply. I know that it doesn't fully follow normalization rules, but the data input forms require it to be set out this way and it works for the purpose required... Any ideas as to the query issue? Imagine the tables were normalized and I had several check boxes across the...

I have a database which has a yes no in each of the tables, set manually to true by the user. I want to query the database to return the fields with the check box true. I am unsure how to do this. I can get it to do it no problem on 1 checkbox.... Please see below a diagram of how I have...

I will use an example database as follows. table x table y there are other tables in the database though! I have a form which I want to use to add/edit data to both tables. the primary key in table x is ID and the foreign key in y is xID so relationship is 1 to many with It seems a...

Can i have a query result as a value in a field? can i have different query results in the records in the same field? I will look at the database design and see if I can find common values for the answers. this might be the way to go as im either working out volume, areas, or linear...

Hi All I am attempting to make a bill of quantities database for a self-build project. Its so I can sort out the management side of my house build. I am now on re-design 3 as I learn more about access, i find better ways of doing the job. I now have various tables with various data sets...

After reading up on normalisation i see that more tables are required, thats relatively straight forward, its the relationship types that i am strugling with, more reading required thanks for all the help to date