Recent content by chieflx

  1. C

    Pivot tables and Totals

    Hi, I wonder if some kind soul might be able to help/advise me on a pivot table design? I want to display the results of a query as a pivot table but my data is all text and I can not work out how to remove the sub total and grand total fields in the pivot table design. I have 14 columns...
  2. C

    Introducing myself

    Hi Everyone, I signed up as a member a few years ago but just realised I never introduced myself :) so I thought I'd rectify that now. I am located in South Devon, England and am currently unemployed. I am trying to teach myself how to set up and run a little database with the intention of...
  3. C

    Primary key problem

    way2bord, thanks for the advice I've not even explored Pivot tables yet so that'll be a fun thing to do I hope. Most animals only have between 5 - 10 papers associated with them so hopefully it won't be too bad
  4. C

    Primary key problem

    CJ London, thanks again I'll give that a go and see how it works. Jdraw, Many species show some degree of 'hand preference' which is commonly known as lateralization. I am attempting to compile a simple database of all the ones I know about and to list the academic papers that support or refute...
  5. C

    Primary key problem

    CJ London, Thank you for the reply, I'll rename the fields and try that. Just to clarify a little about what I am trying to do. I am attempting to create a database that shows whether a particular species is left or right 'handed' and what may affect that Behavioural aspect i.e. is it sex...
  6. C

    Primary key problem

    Hi All, Sorry I didn't make myself very clear, rzw0wr the first table is a species list which includes several aspects of behaviour and the second table is a list of scientific papers and their authors that give evidence for the behaviour. Some of the papers cover more than one species and some...
  7. C

    Primary key problem

    Hi everybody, I am fairly new to Access and I wonder if anyone can possible help with what I think might be a strange problem. I have created a very simple database for various species of animals and the scientific literature that goes with each species. It consists of 2 tables and a junction...
  8. C

    Newbie requiring help with hyperlink function please

    Thank you for the help Linq, would this work even if most of the files I want to link to are saved web pages. Chieflx
  9. C

    Newbie requiring help with hyperlink function please

    Hi everyone, As the title implies I am a complete novice, but I have decided to try and build a database which lists every member of my family. It is so I can track who and what I have added to my family tree. I have designed a form which appears to work reasonably well for my needs but I...
See more
Back
Top Bottom