Recent content by UKFlamingo

Yeah no sweat buddy, Cheers for your help anyway!

Function getDatesStr(period as integer) as string SELECT ID, OurMaps FROM tblMatterList where Job_Status=Live and Matter_OpenDate between dateadd("d", ([period]-1)*14,datevalue("01/01/" & year(date())) and dateadd("d", (([period]-1)*14)+14,datevalue("01/01/" & year(date())) end function...

Sorry I can understand what i need to do but don't know how to write this out. I'll tell you what my ultimate goal is and maybe that may simplify things. I have a table (MatterList) that shows all of our active jobs and the date that they started. On a form i want to have a combo box that...

Yes 364 days is okay as long as it starts on January 1st. And any extra days are fine. I need to make sure a period is 14 days long.

Hey All! I am trying to tell access how long a period is in a year, i.e. There are 26 periods in a year each lasting 2 weeks(14 Days) starting on the 1st of Jan and ending on the 31st of Dec. I need this so that when I type the period into a text box it will update a list box for dates that...

Hello, I was wondering if anyone could help me with an issue I am having. I have a listbox which is populated with data from a table. I have 4 text boxes that when populated with data I want them to filter what is shown in the listbox. I can do this with one textbox using query builder and...