Recent content by bsmithenviro

Excellent, I will have to try and figure that out.

Thanks, that video was interesting; but I am having trouble implementing it. I currently have the query set up with 3 fields selected: "Band_Num" for Row Heading, "Encounter_Date" for Value (Total set to 'First'), and "Encounter_Date" as the "Column Heading". However, since there are so many...

Afternoon all, I'm just a consultant with a penchant for data mining/manipulation tasks. As my career has progressed, I have had to go beyond simple vlookups and pivot tables in Excel (which used to dazzle the uninitiated ha), and I am now trying Access. With that in mind, I already have so...

Hello all! I have what I think is a simple task, but I can't find the available hints on how to do it, so I had to post here. I have a a dataset that has recorded encounters with a number of Banded (identified) animals. It is currently setup so that each encounter is its own row; with all the...