Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SmellyMelly

    excel definition of IS NULL

    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...
  2. SmellyMelly

    Report sorts Date Field as Text

    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?
  3. SmellyMelly

    PCL XL Error on Ricoh Aticio 350

    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?
  4. SmellyMelly

    Group by month when base date field is at daily detail

    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...

Part and Inventory Search

Back
Top