Search results

Thanks Pat. What are the two functions? Can I set the function to start at week 1 from any date - specifically Monday 3rd September 2012?

I wanted to avoid having to create a lookup table each year but I can't see another way!

I'm very new to access and still at the dangerous stage, thinking I know more than I actually do! The data is actually attendance data from a daily (weekday) register. Week one actually starts on Monday 3rd September 2012 as the year is an academic year, school holidays aren't counted as weeks...

I've created a crosstab that returns the following: Row header: Dates (eg 1/5/13, 2/5/13, 8/5/13) - dd/mm/yy Column headings: Monday, Tuesday, Wednesday, Thursday, Friday Values: different text strings (eg, / \ O B etc) At the moment the crosstab returns one record for each date. I want to...

Hi Forum. I'm trying to display information on a continuous form in an unbound text box. The form shows one record for each 'client' with a unique ID. There are multiple records (all with a date entry) for contacts with that client, all linked to the ClientID. The formula I've built is...