I'm not sure if filtering is actually what I want to do? I'm a total newbie, so please be patient with me!
I'm doing wildlife research, and have a ton of data relating to when and where I've seen giraffe of a certain age and sex. I have 2 big sets of data that are related- one that gives information about each group of giraffe I see (the season, the specific transect route, total numbers in the group, etc) called Occurrence Data- and one that has details on each individual (age, sex, other biologic parameters, etc) called Individual Data. I've set up 2 separate union all queries that merge the sheets for the Occurrence Data from each day of work (Occurrence Compilation) and the Individual Data from each day of work (Individual Compilation). I've created a relationship between these 2 compilations that links the unique Occurrence Number, so Individuals can be linked to the Occurrence and the geographic/time data.
Then I've created a new query that pulls out the season, transect, age, and sex for every individual. I can make a crosstab query from that that gives me a table like this:
But this is for all the individuals ever recorded. I'd like to be able to filter this crosstab to only show me individuals from a particular season or transect. Ideally I'd like to do this using a form. I've already got a form that I use to filter the Occurrences that I see based on these parameters, I just can't figure out how to make it work for a crosstab query.
I only barely know how to use SQL enough to have done a Union All query, so if this needs SQL I will likely need some serious hand holding! I hope you all can help me out here!
Thanks
J
I'm doing wildlife research, and have a ton of data relating to when and where I've seen giraffe of a certain age and sex. I have 2 big sets of data that are related- one that gives information about each group of giraffe I see (the season, the specific transect route, total numbers in the group, etc) called Occurrence Data- and one that has details on each individual (age, sex, other biologic parameters, etc) called Individual Data. I've set up 2 separate union all queries that merge the sheets for the Occurrence Data from each day of work (Occurrence Compilation) and the Individual Data from each day of work (Individual Compilation). I've created a relationship between these 2 compilations that links the unique Occurrence Number, so Individuals can be linked to the Occurrence and the geographic/time data.
Then I've created a new query that pulls out the season, transect, age, and sex for every individual. I can make a crosstab query from that that gives me a table like this:
But this is for all the individuals ever recorded. I'd like to be able to filter this crosstab to only show me individuals from a particular season or transect. Ideally I'd like to do this using a form. I've already got a form that I use to filter the Occurrences that I see based on these parameters, I just can't figure out how to make it work for a crosstab query.
I only barely know how to use SQL enough to have done a Union All query, so if this needs SQL I will likely need some serious hand holding! I hope you all can help me out here!
Thanks
J