Recent content by Cristina

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