MNNovice
Last Activity: Feb 17 '15, 08:16 PM
Joined: Aug 14 '08
Location:
-
What I meant is that when the authorized amount was $100 but the expense total was $300 then they have overspent by $200. So the total should be a negative $200. In this example the expense amount is a negative number (over the budget - they will get $100 that was authorized and will be in a hole for the balance i.e., negative $200. This would tell a manager that they will need to transfer funds from another expense account to make the authorized... -
NeoPa,
Sorry for all the confusions caused by my inability to explain things better.
I have a query to calculate a balance amount which is basically the difference between authorized amount ([Authorized])and expensed amount ([Expense]). This query is based on two other queries: one has the [SumOfExpense] and other query has the [Authorized].
Balance = [Authorized] - [SumOfExpense]
I am having problem...Leave a comment:
-
Use of Nz statements for 3 different arguments
I tried to browse through several postings on Nz and iif statements. Coudln't find one that matches what I am looking for.
To calculate "Balance" there are 3 different situation
1. Balance = [Authorized] - [Expensed]
2. For balance where[Expense] = 0 I used
Balance: ([Authorized] - Nz([SumOfExpense],0))
3. For Expense is less than 0 (a negative due to overspending)... -
Got it. Thank you. Much appreciated.Leave a comment:
-
Thanks. But it didn't work either. Here is the actual expression I used.
Balance: IIf([FTAAmount]-Nz([SumOfiAmountECH O],0),[FTAAmount],([FTAAmount]-[SumOfiAmountECH O]))
The balance comes out okay where there is no value for SumOfiAmountECH O. But if I have a value for this field the balance is incorrectly showing up as FTAAmount instead of FTAAmount - SumOfiAmountECH O.
Thanks for your time.Leave a comment:
-
iif Statement not working when there is a zero vlaue
Hi,
My report (rBalance) is based on a query (q3). q3 is based on two other queries (q1) & (q2)
q1 has two figures: Budget amount and Draw amount
q2 has one figure: Authorized amount. This is a calculated field. Budget amount X Ratio %
To get to balance amount. i am using Authorized Amount - Draw Amount.
Everything works except when there is not Draw Amount.
I tried,... -
Exporting Access Data to create an Excel File
Hi,
I am using Access 2007. I have been using an
Access report to create an Excel file by manually entering the same data.
I was wondering if it's possible to export data from an Access report to fill in a customized Excel template. Right now when I select export to Excel from Access report - the result is a messy excel file that requires a lot of time to clean it.
Any lead on this issue will be greatly... -
Thanks for your time in clarifying the issues at hand. I will do my best to recreate the form in question.
Thanks again.Leave a comment:
-
Dang!!!
Well, I had the IT people help me open the updated DB. This is what they did. They opened the DB on a test machine with Office 2013 and saved the DB into a 2000-2003 version.
I was able to open it as well with the latest data. It seems there is one form that's not working. When I click on it, I get this error message: "Cannot save property; property is a schema property".
How can...Leave a comment:
-
Well, that's unfortunate. I don't know when (or if at all), we will get MS Office updated. Until then what do you suggest I should be doing? Hold back any changes to the forms, queries, reports etc.?
Thanks.Leave a comment:
-
twinnyfo & jimatqsi:
Thanks for your tips.
1. Yes, I have Access 2007 at work and 2010 at home. But this didn't cause any problem until a week ago.
2. Yes, I compress and repair each time I close out the DB no matter where I am. But this didn't resolved the matter.
3. Yes, I save a back up copy of the DB at the end of each day before heading home.
4. When I am at...Leave a comment:
-
Sorry, I am confused. How can I import ueries, forms and/or reports etc. without having to open the DB?
Yes, I have several safe copies with only a day old data.Leave a comment:
-
1. I cannot even open the DB. Therefore, importing any forms or queries not possible.
2. Yes, I have a back up copy (my DB is backed up every day at the end of each day). I just don't feel like recreating 6 hours of work ...
3. Yes, a form is executed on startup.
4. What is puzzling is that when I worked on it at home, it worked just fine on my laptop. Eventhough the original was an e-mailed version...Leave a comment:
-
Unrecognized database format
I have been working on this DB for past several years. Sometimes while working from home, I e-mailed the updated version to and from work. Since last week, something went wrong. I couldn't open the DB at work, although it works fine on my laptop. I keep getting this error message: "Unrecogniz ed database format: 'U:\pathname\fi lename.accdb'
So I made a copy of the file on a flash drive from my laptop and tried to open it using... -
Worked great. Thank you for your time....Leave a comment:
-
I actually tried this. But it didn't work. Perhaps because I didn't have the can shrink can grow set it to false. I don't know how to do this. When I look at the property screen under format tabs I only see "Auto Resize" Yes/No. Am I looking at the wrong place? Couldn't find an optrion for true/false.. Thanks for your time....Leave a comment:
-
I need its length set. How do I do this once i set the Can grow/shrink to false on a subreport?...Leave a comment:
-
Access sub report to remain at a fixed length
I would like my subreport to print/view at a maximum of 20 lines data. If i have only 1 line data I would like the report to show 1 line data and 19 blank lines.
Right now, it's shriking or expanding based on data. If I have 5 lines, it shows 5 lines. How do I make it to show 5 lines data and 15 blank lines.
Any help would be nice. Thanks. -
I got the form to work without any error message. Now I need to try to make a copy of DB to another PC and see if it works or not. Shall let you know. Thanks. M...Leave a comment:
-
I verified my codes - it matches that of yours perfectly. Why shouldn't it? I used "copy" and "paste"
The extension was a typo when I was writing the e-mail - that's all.
All I was trying to explain is that the Module 1 contains some codes which refers to another form called fItems. Do these codes need to be modified in any way so that my DB can be transferred from one PC to the...Leave a comment:
No activity results to display
Leave a comment: