Search results

Hi Folks, Thanks for the Iif suggestion. That worked a treat :D On the schema issue, I should perhaps explain that my master data is stored differently and this data extract is in a different format, that I arrived at using a pivot table. I won't be adding any more columns (years) - I'm...

I have a databse of bird ringing (banding) which I have turned into an encouter history by using the pivot table capability in MS Access. Example attached. For each animal, identified by a ring number in column B, there is a set of "encounters" over time. A blank in a date column indicates...

Hi, Tried these queries and it works just fine - thank you :) Is there any way of combining these two into a single query? I have tried but can't seem to do it in a way that doesn't give me error messages. I only ask because I have to run a lot of these with seperate parameters (dates...

Hiya, Many, many thanks for this. I've been away with work for a couple of days but will be able to try this over the weekend. I really do appreciate your help :) and will report back soon. Best wishes Denis

Hi Again, I am making progress with learing SQL and Access 2010 to help me prepare my ornithological data for statistical analysis but I have gotten stuck again. I have a ringing (banding) database with 12,900 records (sample attached). Each record represents a capture of a particular...

Hi plog, Seriously impressed with how little time it took you. I will confess, I am not entirely sure I understand how the script works yet but I will keep trying to work it out. I have a few more queries that require "firsts" e.g. in each year, I need to be able to identify the first...

Thank you for the suggestion, jdraw :) . It's not quite what I needed but thank you for taking the time to look for it anyway! Best wishes Denis

I can't thank you enough for this. I have been trying to fathom how to achieve this for days. I haven't tried it on my full dataset yet but I'm sure it will be fine. Can I ask you please how you did it? I presume you wrote this directly in SQL rather than using any of the query tools in...

I’m currently analysing some bird ringing (banding) data.. I want to examine how various measurements on the birds change as the birds age. If anyone wants to know why, happy to give a more complete explanation – it’s not just “because it’s there”, there are real conservation and wildlife...

Hi, I'm currently trying to analyse some bird ringing (banding for the North American folks) data from the UK. I'm not doing this as part of my job; at the age of 51, I decided I was going to do an MSc in the subject of my first love; birds. In working on my dissertation, I've already...