Search results

Wasn't sure if it was a query or a table problem...posted in both to be sure.

Here it is. I'm sure how I have the last field is probably wrong. SELECT AccountData.ss, AccountData.account, AccountData.date_service, AccountData.total_charges, AccountData.[3rd_party_payment], [total_charges]-[3rd_party_payment] AS account_balance...

Yes, it does make perfect sense. But can you still do this if the fields in the calculation are in 2 different tables? account_balance is a field created in a query using total_charges and 3rd_party_payments in the AccountData table. That one is no problem. However, I'm running into problems...

I can't get it to work in the query....it DID when I had everything in one table, but now that they're split into two I can't get it to calculate. :(

Is it possible to create fields in the table that are based on calculations from other fields, instead of on user input? I have a table AccountData with several fields, including total_charges and 3rd_party_payment I want to create a field account_balance that would be the total of...

Didn't work. :(

Does the information on your main form and the information on a subform have to be on separate tables?? I have a database that will track applicants to our financial assistance program, as well as their account information. Each applicant could have many accounts. I DID have everything on...

Yep, they are exactly the same and I still get prompted to enter a field. What is the correct way to type it? fap_payment:[account_balance]*[percentage]/100 or fap_payment:[account_balance]*[ApplicantData]![percentage]/100 or something entirely different? The field account_balance is not...

I'm trying to create a field that is a calculation based on 2 different fields. It's account_balance times percentage divided by 100. My problem is that account_balance is in the AccountData table, and percentage is in ApplicantData table. Any way to do this? I currently have in my query...

I guess I'm not quite sure what you mean by make a query out of my table. Maybe I'm making it harder than it really is...

This is probably very easy to do, but I haven't figured it out. I have a database for storing our Financial Assistance Program information. There are 3 fields that are calculated based on information the user enters in other fields. Currently these fields are calculated and displayed on the...

I have a database with some calculated fields that is really confusing me. I posted about it earlier and got some responses telling me that I don't want to store the calculated total, just the calculations themselves. I haven't worked with it since then and now that I'm getting back to it, I'm...

Never mind, it worked. I forgot to change my field name from what you had to what it was actually called (ReturnDate) Thank you!!!

Thanks for your reply. I did what you suggested, but when running the query, I am prompted for a return date. I'm assuming that's not what you intended...?

I have a database I set up for a department to keep track of charts they send out, where they go, and when they're returned. There is getting to be a LOT of records in the database, so I'm wanting to set up some kind of purge function for them. I know I can set up a delete query but I have a...

Our facility has a financial assistance program (FAP) that will pay for a percentage of their bill if they qualify...based on family size and annual income. Currently they use several spreadsheets to record the data, and do a lot of manual calculations. I'm going to set up a database, but want...

Yes, I made an unbound text box in the report footer. I went into properties and in the control source typed in =Count(*) The count should be maybe 25 records or so, and I made the text box about 1/3 of the width of the page, so that shouldn't be a problem. When I run the report I get...

I get "Error" in that area when I enter that. Can't believe how frustrating this is, for how simple it seems!

I get "Error" in that area when I enter that. Can't believe how frustrating this is, for how simple it seems!

I have a database set up tracking work accidents, etc. They have had me set up several reports showing various information, which I have pulling from various queries. Now they are wanting a COUNT of all records on each reports. Doesn't seem that difficult but I can't figure out quite how to do...