Search results

Hello, I'm hoping someone can help with the most efficient way to do this. Every month I download a billing report listing costs for several telephone numbers. Each cost is broken down separately by description, so each .csv file equates to about 12,000 rows in Excel. I've attached a shortened...

I copied an Excel macro from a previous post to check cells in column A for data, and if no data is found there to delete the row. The code is below, but how can I modify this to check cells in column B or C instead: ----------------------------------- Sub DeleteBlankARows() Dim r As Long...

Hello, hopefully there is an easy answer to this. I have a form with a combo box linked to a query containing department names. I used code I found named AddAllToList to create an "all" option in the combo box. Everything shows up fine, but the problem is I have another query that uses the...

Hello, hopefully a simple question here. I have a report with 6 months of usage for many lines. Each line is separate and I have created a text box that averages their usage for the 6 months in the group header. What I'm trying to do is make a front page listing the number of lines with averages...

Hello all, Please bear with me as I'm not very knowledgeable when it comes to code. My hopeful result is to select multiple Departments from a list on a form, then run a report based on an existing query with the selections in my list as a criteria. I already have the report completed and...

Hello, I need major help with multi select list boxes. I've researched for hours, but am stuck on two things. #1 - One of my queries (that leads to a report) is a combination of fields from two related tables. For some reason, the multi select box on the form I created always returns null...

I thought I may have better luck posting this in here. I've got a report that lists monthly charges, based on a query with a date parameter, and is sorted by department. I am not very familiar with coding at all and am trying to figure out how to send each department's charges only to a...

There has to be an easy answer staring me right in the face, but I can't see it. I've got two tables: one for charges, one for credits. Both tables are updated on the 15th of the month with new charges or credits with a listed mobile number. I need to run a report each month that includes the...

Hello all, I'm using Access 2007 and am stuck with a Union Query. For a bit of background, I have two tables with cell phone billing information. The first table lists information about the users, such as name, number, department, etc... The second is a downloaded list of charges for the month...