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!

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

Recent content by Ryan0001

  1. Ryan0001

    formula problem

    im not sure which function or formula will be able to do this, but im sure u can help me out. ive got the folloing in a report: Amount Income/Expenditure ....... .................... ....... ..................... I want to calculate the profit, i.e. Sum of income- sum of...
  2. Ryan0001

    UNION Queries

    Ive got a problem concerning union queries. I have a financial statement report based upon a union query which combine data from 4 tables. Its quite complicated, with a lot of calculations and parameters, but the basic structure is as follows: SELECT [Date], [Income], "" As...
  3. Ryan0001

    IIf fUNCTION

    ive got an invoice for a mail-ordering system. ive also got a form to enter in the order details. if a certain condition is met i need a table with various headings and values to be inserted. if this condition is not met, i don't want the table to be inserted. i managed to do this by having IIf...
  4. Ryan0001

    Query Relationships

    Thanks a lot…the union query was the solution and it worked. However ive got a few more questions concerning this topic and would appreciate if anyone could answer them: 1- I wanted to put a parameter on the query, but it wouldn’t work. So I created a normal query, added all the fields from the...
  5. Ryan0001

    Query Relationships

    ive got a bookshop database + have a problem with 2 of the tbls: 'BookExpenditure' (money spent on books) + 'MiscExpenditure' (rent, bills etc.) i also have a report based upon a parameter query which shows the expenditure when you type the begining and end date. the problem is that the report...
See more

Part and Inventory Search

Back
Top