Search results

My wife :(

Welcome back.

You're welcome.

Left(Forename,1)

I meant like a toothache. You don't like it any better but you get used to it being there.

Don't be put off, Jambo, you get used to this after a while. ;)

Tools - Startup, alter the 'Display Form/Page' setting.

There may well be an easier way, but you could do it in two stages. 1) Select all sectors from the table - no Yes/No where clause here, just the date range - into a new table. 2) Select all sectors from the new table LEFT JOIN to the original table, on sector and date range. Also select the...

Treat the null as a zero, for the purposes of your calculation e.g. Total = IIf(isnull(Field1,0,Field1)) + IIf(isnull(Field2,0,Field2)) In other words, if Field1 or Field 2 contain anything at all, use that value, otherwise treat each as if it contains zero. Hope it helps.

'DoCmd.OpenForm' allows you to either use a pre-specified filter or a where clause.

The whole thing, hollowed out and carved a face. I forget whether the insides were eaten or thrown away.

I need to produce a lot of Access reports as Excel spreadsheets, as the company I'm working at likes to play around with formatting. The easiest way i've found of doing any of the formatting stuff is to 1) Open a blank sheet in Excel 2) Start recording a macro 3) Carry out whatever steps you...