Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lostris

    Dates, Reports & Union Queries.. oh my!

    ok, I know there's a way to do it - I've skimmed over it somewhere before and it didn't dawn on me til just now. I have a report being pulled off a union query, I need it to run just for certain dates of the month. From the 29 of the month to the 28th of the next. pleease tell me there's a...
  2. lostris

    Confused about whether to use a macro or a module

    I need to have a report prompt the user for the dates before it runs.. the query that the report is running off of is a union query, so I gather i have to use either a macro or a module.. only hitch is I don't know which one to use or how to use them.. I've never messed with them before and am...
  3. lostris

    Parameter Query in a Union Query?

    Ok.. just one last question and this report is done - I swear I'm not going through this again heehe I have a union query bringing together 7 different queries.. I need the union query to be set up so that when I run the report it prompts the user for the month or dates or whatever.. I can do...
  4. lostris

    Adding two different totals from one entry at the end of a report

    Ok.. I REALLY hope someone can help me with this - its just one of the last two things I have to figure out before this cursed thing is done.. First off, just so you know how its all set up, I have seven different queries doing seven different pricing equations (couldnt figure out how to get one...
  5. lostris

    Bloody duplicates....

    I can't find anywhere how to get a union query to stop duplicating entries.. any idea's?
  6. lostris

    IIF Issues

    Ok - I know nothing about IIF, visual basic, sql.. I'm not a programmer. I'm currently setting up a database for my employeer.. one report that I have set up is an invoice. There is one section of the invoice that is causing issues. I need one column to automatically calculate a price based...

Part and Inventory Search

Back
Top