Search results

Nice tip. I will have to try that out! Thank you.

I just wanted to submit this solution out here so in case someone runs into the same error they will know how to fix it. I have a module that sends emails out of Outlook based on information that is pulled into Access via an Excel worksheet. When I went from Access 2003 to Access 2010 I was...

Have you tried using the Report Wizard?

Hello all, I have two reports I have made in Access. Is there a way to create an Access report that allows one report to flow right into the other report? Or have Access export both reports to the same file in Word? That way if I was to print out the report in Word it would just be one...

Hello, I have a report that is pulling its data from a query. In the query I have two tables. One that pulls in the invoices and the amount of each invoice and the second table that pulls in the total amount of the invoices by account, the account total. The problem I am having is when I run...

Hello, I have a query. In the query I have two tables. One that pulls in the invoices and the amount of each invoice and the second table that pulls in the total amount of the invoices by account, the account total. The problem I am having is when I run the query The account total duplicates...

Hello, I am new to creating subreports. I want to create a subreport that just shows up on the first page of the report on the right side. The problem is when I add the subreport it moves everything in that Header field up. So I have the titles and under the titles a bunch of space and then...

Thank you. The Mid() expression was exactly what I was looking for.

Hello, I have a table with an account number field. It has about 400,000 account numbers. The problem I have is every account number has two zeros infront of the account number. For example, 00712394. Is there away to do a update query to delete the two zeros from the front of the account...

Hello, I have a form that has a list of Employee numbers and when you double click on an employee's number it opens another form that list all the accounts under that employee number. Everything is working fine except there're a couple of duplicate employee numbers for the US and Canada so...

Thank you. After playing around with it for a while, I was able to figure out that access would let me do that automatically with its group by and max function in the query design view!!

For example the query could return this: Invoice # Amount 5890 $23 5890 $29 5890 $45 5890 $67 5890 $258 And I would like it to only return: Invoice # Amount 5890 $258

I have a query that matches amounts to invoices. So when I run the query there can be 5 of the same invoice but different amounts for each of the same invoice. Is there a way to make the query only return the largest amount for each invoice?

This sounds exactly like a problem I had a few weeks ago and was helped. Like they were saying above me, try a Union query. Here is the instructions that was given to me and it worked perfectly. In your case instead of 3 queries you will need 13. Also, I had to use brackets [ ] around my qry...

I figured making a separate query would be the easiest way to get the top 10 values but, how do I specify which field I want the query to use to determine the top 10 values?

Hello, I have the following union query, is there away for this query to output only the Top 10 values? select * from [Highest Impacting AR Reserve Invoices] UNION select * from [Highest Impacting FM Reserve Invoices];

Hello, I have a table that gets updated data monthly from an update query that I run at the beginning of every month. The table has the fields Account #, Acct Amt, Days over due, and date of last payment. This table keeps track of any accounts that have any over due balances that have not been...

haha. This makes me wonder what else Access can do that I had no idea about. I have been using Access professionally for about 3 months now but, I used it all through out college and I had no idea about the "union" function. Thank you again, now to figure out what else I am missing out on in...

OMG, you are a genius!!! That worked perfectly!!! Now, I just have to do a little fine tunning and I will be done!! Thank you again!!! You truely are a life saver !!!

Right now I have the one column. But I would like the one column to be able to sort the 3 columns as one. So instead of 1 1 1 2 2 2 I need all three of those in one line 1 1 1 2 2 2 Does that make sense? I am trying to see what the top 10 numbers are from all three columns and if I...