Recent content by Grey Whipple

ACCESS 2003 I am creating a report that has two date fields: HireDate and EndDate. The EndDate field in some records has a value, but most of them are empty (null). Where null, I want to insert the Current Date from whence I can determine how long a person has worked. I am trying to use an IIF...

I have inherited two forms, one that creates drop-down list data, and the other that reads and displays that data. The first form seems to work perfectly. It inputs and saves 5-char mnemonics that start with the letter "T". In Design View the leading "T" is displayed. When the second form...

Gadfry, Now I'm looking at SQL code, and I have solved my problem! I moved the Status variable, saved it, ran it, and voila! GW

Further snooping around has not yet revealed the existence of any sub-queries, but I have discovered another situation. My Report references a Select Query. The Select Query works just fine and all the fields I want to use on the Report are present and all the data are present in the Query...

I have inherited a Report that includes a Parameter Query to input a value. I want to change the 'user prompt'. The Parameter Query does not appear to be part of the underlying data query that supports the Report. And I do not find anything in the Report that sets up the Parameter Query. Any...

Many thanks to Mark for taking the time to respond. The winning expression is =NZ([01])+NZ([02])+...+NZ([12]). Grey

I have inherited an Access DB that accumulates 'hours worked' by name and date. I also inherited a cross-tab query that displays monthly totals by name and month. Each row is for a different person and each column is for a different month. I use the Report Wizard to create a report that reads...