Search results

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 Access family, I have been trying to get some help for some time with this problem. Maybe I was not explaining properly, so I will try again to see if I can get this across properly. I have a database for an account that has deposits and expenditure, The budget is three level eg...

Good day , I need some help with a form. Two tables in my database...budget and expenditure have a common field ITEM CODE, set to data type TEXT I have a form to input expenditure and to read the Item Code from the Budget to input into table Expenditure. Whenever the Item Code ends w ith a zero...

Hi all, I put this post before, and no answer, I search the forum but cant find and answer that I can use, as I need basic help. I have a database tracking a budget. It is like a cash boom. I have deposit and make payments. Supplier, invoice# etc. I would like my form to show a running...

I have a table with about 16 fields.. Including in the table is one for deposits ad one for checks or fees. I would like to have a running balance on the form. Grateful for assistance. Tks Cristina

Hello All, I need some help with a report. I have a table with expenditure that is reported on quarterly. summary report as follows Budgeted Amt spent previously Amt spent this quarter Balance I also have to do a detail report, in the same format. It is not working out...

Good day, I need some help with a form. I have a table with one field -Exchange rate. I have a form to input the exchange rate when the rate changes. I have a form to input data into my Expenditure table, and a combo box to read and input the exchange rate into the Expenditure Table from the...

Good day All I have a form to input data into a table1. On the form I have a combo box to read from a next table exchange rate to input into the table1. Field in Tablet for the exchange rate is set to Field size double, Format currency, and decimals 6. I am unable to set the field...

Duplicates in report Hi All, I need some help with a report. My budget in the database has three levels. Main Heading 1 Account 1.1 Item 1.1.1 etc From the Dbase, I am supposed to run four reports quarterly. One a detail of all transactions by item, account and main heading One a total expense...

Good night All, I do hope I can get some assistance that I can understand with placing a filter on a form. I have a table that needs updating. I created a form based on the table, but would like to only see the records that need updating, instead of the entire table. I have no SQL knowlegde...

Hi All I need help with a form and subform. I have a main form EMPLOYEE RECORDS with employees information, with a Subform, where pay records are entered. Mysubform always shows record 1 of 1, and I cannot scroll back to see previous records. How can I see the previous entries. Thanks

Hi all, I have this code I got from this forum. It converts dollars in numbers to words for a check. So it converts to Four Hundred Seventy-Three and 21/100 I would like it to read Four hundred and seventy three dollars and twenty one cents. Please for some help Thanks 'This code was...

Hi, Can I please get some help with this problem. I have an ACcess Database file on a network. However it can only be opened on one computer. The Dbase opens up to a main form called Data Entry. It contains buttons to access other forms or reports. On opening on the other computers an error...

I have an access form that calculates workdays excluding holidays keyed in a tabe, and weekends. When I put a date in 2011 it does not take into account the holidays. I am new at this and actually got this from the internet. Can someone please adjust the code so it takes into account dates in...