Search results

Hi, I have a query where I'm trying to calculate the number of days between 2 fields. There are some fields which don't have a date/are null. I want to make the result for those a zero. I have tried a few different ways (iif statement, Nz function, IsError etc) nothing seems to work. Below is...

Hi! I am trying to do what seems to be simple: I have a report showing on time delivery % by month and year for customers...I simply want to display a bar graph showing the month&year and %. (the query already has a calculated field with the %) But this seems to be such a challenge.. (I have...

Hi, I have the following macro to delete blank columns...how could I alter this to skip the first row (not look at the header)? It thinks the column is not blank because there is a header in the first row, but the remainder of the column might not have any data. I want those deleted...

Good morning, I have a report with a textbox that has an expression in the control source, pulling from a query. I want it to pull all the records in the query into that one textbox (and have them in sort of a list, if possible). Instead what it is doing is pulling the first record, then...

Has anyone had any problems with Access 2007 running on Windows 7? I have had a lot of random issues and suspected it may be due to Windows 7....spent many hours this week troubleshooting reports I have built, mainly because IIF statements were not working in a control source. I finally rebuilt...

I have been trying to figure this out all day. Any help would be greatly appreciated! I have the following IIF statement in the control source of a textbox on a report: =IIF([StartDate]=#8/15/2011#,[EmpName],"") I simply want it to look at a table that has Employee information, and if the...