Search results

  1. A

    Query Problem

    Ok I did a crosstab query and it worked! You guys are awesome. I did run into another problem when I tried to import the whole spreadsheet from excel into access. What does this mean?
  2. A

    Query Problem

    I am using a sum in the query. This may be solved if I put it into one table, I am going to try that and then see what happens. I will let you know. How do you do a crosstab query?
  3. A

    Query Problem

    Correct me if I am wrong (I probably am) but there are two problems with that. 1) I am at almost 500,000 lines (records) of data and growing, won't that be too much? 2) I want to see the information month by month side by side so something like this customer name .February Sales...
  4. A

    Query Problem

    Yes there is a table for each new month
  5. A

    Query Problem

    Ok, I am a new access user so I am hoping that someone can help me with this problem. I have been extracting sales information out of my accounting software and making sales reports using pivot tables. The input spreadsheets have grown way to big (like over half a million lines), so I am...
Back
Top Bottom