Recent content by AnitaPita

I able to get it to work but I did it in Access 2010. Pretty sure that was some kind of bug in 2007 or I was missing a patch/update for 2007. Ahh the joys of Access!!!

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

I am late to this conversation but I wanted to say I just got done doing this...I created a calendar for my department that has a user interface/form where people enter their data and it appears on a calendar by month... I used calendar controls in the form where the users could input using a...

Got it!! Thanks for all your help!! :)

Thank you! Right before I read your post I started thinking I could try a subreport, will probably just be a pain formatting everything...now I have hidden the header of this subreport but it still has a colored background? Any idea how I can get rid of the design in the back? I have tried to...

Hello again, Yes I moved everything up and the next record did appear, but the problem is by moving the footer way up it messes with the formatting of my report....I have set this up to look like a calendar...So for instance, I have an August calendar and I have 2 records from my query that...

After doing some research, I believe what I need to do is concatenate the multiple records in my query into one record.... :confused:

Thanks Mr. B, I shortened the height of the Details section, but the text box is still only displaying the first record in the query. I've got 3 employee names in this particular query along with a reason they were out of the office. So when I pull all the records, I want it to display...

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

My table is linked to a form that is being used for data entry...so we can track out of the office/vacation time. So an employee can have more than one record with their name. So one entry could be John Doe for Vacation on a certain date then John Doe again for Floating holiday on a different...

Hi how do I post the db? Sorry, I've never done that before. Thanks!

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

Hi again, no the date doesn't have a time...I originally had it formatted as "short date" then I even reformatted it to a mmddyy and it still wouldn't pull it. On my home computer it pulls but only gets the first record. The table I have is small, has only 20-30 records right now... I can create...