Search results

Hi I'm wanting a macro that will erase the contents of 12 tables (but NOT delete the tables) in one go i.e. I don't want the user to have to click 12 delete queries or have 12 delete queries visible in the Object Navigation Pane. I instead want one macro that will do it all. In the macro...

Hi See attached spreadsheet for an illustration. But note, the values in ProgramDetails are Text in the real database For quick reference, a slimmed down version of the data looks like this: ProgramList PROGRAM.......START_DATE X-ABC123....... 12/04/2012 None in force...

Hi Pretend I've got 01/01/2000 - 01/01/2004 33 players in squad 01/01/2004 - 01/01/2007 25 players in squad 01/01/2007 - 01/01/2009 25 players in squad 01/01/2009 - 01/01/2012 47 players in squad With how it didn't really change on 01/01/2007, is it difficult to write a...

Hi, I don't think I'm quite at intermediate level yet with writing queries so I am a bit out of depth with this one. I've got data that tells you Team A was doing 50% of the work between 01/04/2011 and 12/01/2017 Team B did the other 50% between 01/04/2011 and 14/11/2015 but on...

Hi I'm fairly new to Access. All I can do so far is tweak an existing query or setup the most basic select query. I'm trying to setup what I thought would be a basic query but I'm puzzled. There's various select queries containing useful and useless results. I want to create a select...