Search results

  1. B

    Compile error: User-defined type not defined

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

    Compile error: User-defined type not defined

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

    New to Access...Report Help from multiple queries

    Have you tried using the Report Wizard?
  4. B

    Multiple Reports Outputing to one file

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

    Duplicate Numbers in Report

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

    Duplicate Numbers in Query

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

    Subreport Problem

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

    Update Query - Delete Part of a Field

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

    Update Query - Delete Part of a Field

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

    do.command Button code - Form

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

    Duplicate Records

    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!!
  12. B

    Duplicate Records

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

    Duplicate Records

    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?
  14. B

    Joining Queries

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

    Selecting Top 10 Values

    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?
  16. B

    Selecting 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];
  17. B

    Delete/Update Query question? Is there a way to do this?

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

    Multiple IIF statements in one column?

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

    Multiple IIF statements in one column?

    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 !!!
  20. B

    Multiple IIF statements in one column?

    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...
Back
Top Bottom