Search results

Done (I think)... file attached... Seemes to don "exactly" what I need it to do Each Period in the query, uses the line below, just changing the Period each time to P1, P2, etc.. Cheers Ronan

I've had a little success, but now I get the days, but not for just the periods they land in.... I used a Module(Function) to get the working days.. I've attached an updated file.. Cheers Ronan

Hi :) I understand the DateDiff functions etc... But can't work out out to pull the right data from the right periods. There are 2 tables, one with the Course Details and the other with the period Details, but still can't get it to work... Cheers

Hi I have a database which is unfortunately in Access 2000 due to that being the only version available within the company. I need to query the number of days that fall in each period (13 periods in the year). I have attached a sample with 3 records in the table. Course 1 = 5 days in...

Thanks, I have a good idea regarding the IIF, it's just putting it into a module as a built in Function, I struggle with... Cheers

Hi I have a large piece of data which I "was" minipulating in Excel, using complex formulas and some vba, but as I know will be looking at various reports, I have imported them to Acess as tables... And was trying to query the table na dpull the number of days. Unfortunately I am struggling...

All done, I created an append query to update the details table with 20 objective ID's for each new role added and assigned that to a macro to run when the user presses the add role button. Thanks Ronan

Done a little VBA. But not something I have really gotten stuck into. I suppose I could do an update query too. Have it so when I add a new record to the Roles table, it will automatically add this to the RoleDetails table, 20 times with the corresponding 20 RoleProfileIDs. Sound like a plan?

Arrgh. Programatically. New learning curve begun then :o) Thanks for the advice. Ronan

Thanks for that Mmmnnn. The level (could actually be one combo box as all is needed is to choose one level based on each of the 21 profiles for the level(Each Role has 21 profiles and each profile has 4 levels 1-4 (just changed this))). So Role1 has 21 profiles and Role2 etc also has 21...

Many thanks for the reply, I will give it a go this weekend, and see if I can work it out. Thanks again Ronan

I have 3 tables as below... Fields Level 1 - Level 10 are Yes/No fields. I need to set it up so that in a form when I had a new role, there are the 10 Yes/No fields available to assign the checks to. Each Role will have 21 Profiles (which don't change) and each of the Profiles will have...