Search results

Hi, I appreciate your input. I think I understand, that you should not use Minimum and Maximum , as in the example of my Income Tax Table. IncomeTax PayRangeLow PayRangeHigh TaxAmount $1,060.78 $1,060.97 $44.08 $1,060.98 $1,061.17 $44.13 $1,061.18 $1,061.37 $44.18...

Thanks everyone for your input. I used the max with the suggested query by CJ_London and it worked well. There was not a problem with the range. Cristina Seawell

Thanks you so much. It worked like magic, wish I understood the reasoning behind the code. Very grateful for your kind assistance. Cristina

Thanks. I checked the data, and there is no variance from the previous month's Gross. They are in the same range. Would you please guide me on how to modify the query. Somebody helped me with that last one. I am not good at SQL or complex querries Thanks

Good evening, I need some help with a query which has been working for years, and just now is giving me a error. The query calculates income tax - Taxes: (SELECT T.[TaxAmount] FROM IncomeTax AS T WHERE [PayRoll Table].GROSS Between T.PayRangeLow And T.PayRangeHigh) It is an append query...

Hi Shoji, Thanks very much for your help. I figured out how to get the current records. I took the total TotalEUspent and subtracted the previous records. And finally figured how to deal with the totals etc. So grateful for your help with the UNION query. Kindest Regards Bernadette

Hi Shoji, I am still working on the last report data base. I studies the Union Query you suggested. I created a union query giving me the total budget for each item code, accounting code and Main heading. I was hoping to add that to my Query QryDetail Budget Consumption, but there was no data...

Hi Shoji, Please bear with me. I went over and redid the last query. Disregard portion of previous email regarding the queries and Report.(Detail 1) The Query QryDetailBudgetConsumption shows up correctly for the current records, however in the report it shows up 'error". However the...

Further to last post: in Eg 4.3.1

Good morning, Thank you very much for taking the time to understand my problem, I am almost there. Two problems: 1. In my report, the current expenditure data that showed up as symbols show up as ERROR .(so the total also shows up as error) This is what I did. The expenditure report...

Here is the database

Good night, Thank you very much. Sorry, I don't know anything about union query so any advice you can give me would be appreciated. I need to add the budget so I can get the the balance for the report. When I run the union query the amounts for current expenditure show as symbols, resembling...

I appreciate your help and look forward to hearing from you tomorrow. I hope I have explained what I need adequately. Cristina

See other attachment

Observations: The Amounts in the budget table are in Euros, so in your query qryBudget_EU, the figures should not be converted. In the qryExpenditure_EU, when converting to EU we divide, as it is 1 EURO = 2.19490 Bze and the amounts in the expenditure table is in Belize $. After doing that...

Thank you. I will go through it. Much appreciated.

Hi, Let me explain. The DBase has a table named EXPENDITURE. The report is to show for any given date selected...all previous expenditure before the begin date (PREVIOUS RECORDS) and all that date forward (CURRENT RECORDS). Match with the Budget by Item Code . One report is a summary, so for...

Thanks for answering. On the attached PDF named screen - a picture of the report form. At the bottom you will see two separate reports. One named current report and one marked first report (which is actually the previous records) which are the details matching the Summary table of budget...

Hi, I am attaching another version which is a bit clearer. When database opens, choose open report form. In dialog box type beginning date July1 , 2015 and ending date August 12, 2015 (1) Run report SUMMARY TABLE OF BUDGET CONSUMPTION BY BUDGET . Note the total for the report...

Thank you. I have attached the file.