Search results

Thanks for the response - I apologise if my proposed solution isn't ideal... I want to achieve a list of depts in a single field in a query that can be exported to excel and displayed alongside the rest of the record. I couldn't work out how creating a seperate table with multiple rows could...

Ok - need to explain what I am trying to do and why... I tried and failed to get this to work using a multiselect listbox... I have a list of departments in tblFunctionalArea My main table is tblStatic I want to be able to for each record select multiple departments affected by a record and...

Hi - I've found a way round this although someone may still come up with a 'slicker' solution... I created a find unmatched query on the main ID field which forms the basis of the relationship and found the new ID's - I then created an append query which added records to the tblStatic with...

Thanks for your help Pat before but if you and/or anyone can help me some more of this I would be grateful... My challenge is that my two tables tblImport tblStatic tblImport is the one on a daily basis I will want to clear down and reimport and this is working ok - I can delete the...

Thanks Brian - sorted (again!) :-)

I'm thinking I need to use this within the main query that is the source for the form instead of calculated within the form itself... I reached this conclusion after needing to scroll through all 1000 records to populate the detail in the query... I figure this isn't ideal and should be...

No sooner do I post then I work it out... For anyone else with this challenge, here is my solution... Fix RAG: IIf([Actual Fix Date]>0,IIf([Fix Date Variance]<=0,"G",IIf([Fix Date Variance]>5,"R","A")),"N/A")

Hi, I had a Nested IIf working fine... Fix RAG: IIf([Fix Date Variance]<=0,"G",IIf([Fix Date Variance]>5,"R","A")) Well working kind of... as where the Actual Fix Date was blank it showed #Error... So I tried to include an And in there as well and think I've thrown the arguemets out of the...

Thanks Brian - saved my sanity again!! :-) Perfect!

Hi everyone - I have some code I found and am using that appears to be throwing some strange results out... I am calling the following code in a query using Age of Defect: Workdays([startDate],[endDate]) Public Function Workdays(ByRef startDate As Date, _ ByRef endDate As Date, _...

All working! :-) many thanks

Just quickly how would I call that either in the form or via the query that sits behind the form?

Thanks Brian - I've left the office now but will give that a try tomorrow - I'll let you know how I get on. Just wanted to thank you quickly for your time while I knew you were online!

Hi Brian, Thanks for responding - yes I have found some Select Case code (but I have never used it before in any of my simple databases I've built...) that is kind of like that... but I can't work out; 1 - how I get the "day" from a date i.e. 28/01/2013 = Monday 2 - how to get it to look for...

I'm still stumped on (2) Calculated Target2 Date With this challenge I need to be able to take the previously calculated Target1 Date and calculate the next target date. For this it can only be a Tuesday or a Thursday, so I need to be able to take Target1 Date and then calculate the date of...

That's perfect Pat many thanks - I'd never heard of DDL queries but I took your example and implemented it and it works a treat! :-) Thank you so much for your response

Hi, I have two tables linked with a 1-2-1 relation with enforced referential integrity based on a input ID field. I originally had autonumber field which was the primary key on them both but then wasn't able to update any of the fields. I then deleted the autonumber fields and made the manual...

Ok quick update... I've sorted (1) but any ideas on (2)? I'm still stumped... ?????

Hi everyone - I've got a couple of interesting challenges that i don't know where to begin... I have a WorkingDay module (found elsewhere on this forum :-)) that is working well for me elsewhere that feeds off a holiday table etc (1) Calculated Target1 Date With this challenge I have a start...

Thanks David, I think it will need to be closer to the second option you mention there... I may need to create a date table which stores month name i.e. February 2013 and then 28 dates and then March 2013 which stores 31 dates etc Then I could choose Project A and then February 2013 and the...