Recent content by SmellyMelly

worked, thank you!

I want to create a result of null (not zero) in an IF statement in excel. This is what I have: Cell G15 =IF(ISERROR((D2-E2)/E2),"",(D2-E2)/E2) Cell N15 =IF((G15>=1),1,0) The problem is if G15 is blank (is null?), cell N15 calculates a 1. Question: are the symbols "" the...

I've got a report which sorts the date field as text. The underlying query has formatted the date from DD/MM/YYYY to MMM, however when I use the formated query field in the report, it is treated as text (ie sorts alphabetically). Any ideas how to tackle this?

I'm trying to print an access report (nothing fancy), when I get this error from our network printer. subsystem: Kernel error: insufficient memory operator: rectangle position: 35 is this a problem with my pc, my printer drivers, or the printer itself? Is this related to Access? Any ideas?

Thanks! the query worked with that as a GroupBy, and a custom date format in the field properties. Now to get it in the report!

I would like to create a report where the data is grouped by month by division. My data is at a daily level. When I use the grouping function in the report however, the results is one group by division, with several entries per month. I thought to create a new field in a query to extract the...