Search results for query: *

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

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

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

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

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