Recent content by Buckster

Okay! I got this! Once I realized that it doesn't necessarily have to be sequentially numbered in the table because I can just resort as needed on the queries that pull from the table in the next steps, I gave myself a whack for over-thinking it, and hit the gas to work up the queries that...

Thanks so much! I think I may have just hit on a way to exclude the first record in the set during the query. I made a separate query with a single field to just identify the lowest [PoleNumber] with a Min, then used that query as part of the append query to exclude that [PoleNumber] IF it...

I actually have that data and could use it, but the "first" record in the dataset that's generated is "first" by other criteria than that, so that date method would choose the wrong record to delete if I included and used it. Maybe if I do a better job of explaining, it will help you folks...

That's a really good point, and I'll have to think about how I might better pull this off to ensure the end users get the right info on the output. At the moment, I can't think of a common thing that would help me exclude that single record with a query each time the end user runs it because I...

I've got a situation where I need to append data to an empty table that will autonum the records for me, delete the first record of that table, run a series of queries using the table's data without that first record, then delete all the records from that table again to set it up for the next...

Fantastic! Thanks so much!

I had a large table with 60+ Boolean fields in it (Yes/No). To make it web-ready, I had to reduce that number to <30 per table, so I separated the table into multiple tables of info. I'm looking for a way to keep the input form that used to access and write to this single table intact because...

Just joined and thought I'd say hello below I jump into further posting. I'm no guru by any means, but I've been working with Access for more than 10 years, so I mostly know my way around the simple stuff, at least. Every once in a while though (more often as I get older!), I have myself a...