Search results

i have tried to piece together some code which will change the colour of a week number dependent on certain parameters. I am not a programmer, so please if it is poor,allow for the newbies on town. Here goes. I have two cells in a report one called 'year' and one called 'weekno'. i want the...

I have a report that looks at a query. The base data contains a field called 'functlocation'. Now this data can vary in length and looks something like the following 12080026335PDPV5448-1 12080025507PUMP 12080004003BUILDINGS 12081925507PUMP 12081925507PUMP Now the first 6 digits represent a...

Within a report i have a text box referenced 'Week'. The data from this comes from a query that references a cell called 'Week'. 'Week' gets it data from an adjacent cell called 'Lat#finish date'. It uses the code Week: Format([lat#finish date],"ww") to return the week number. I want for the...