Search results

I have a bound form that is used to enter company info (address, name, category...etc). When the user closes the form, if Company name, province or category are left blank, I warn them with a message box asking if they want to exit and undo changes, or return to the form to fill in the missing...

Hello, I am trying to display a number such as this: $7,018,901 as this $7.0M. I am using VBA with a DSUM to calculate the textbox value using this expression: ContributionINDCAN = Nz(Round(DSum("Commitment", "qrymetricsproject_all_CAN", _ "[ProgramtypeID] = 1"), 1))...

Currently support for Access 2013 is extended to 2023. http://support.microsoft.com/lifecycle/?p1=16632

Argh.....I had my subform named after the table its based on...not subfrmHQPProject. Thanks for the help!

I have a form with a subform which resides in a tabbed control. In that subform, I have a textbox in the footer that sums values in the detail section of the subform. I have a textbox on my main form that should display the same data that is in my subform footer textbox, but it is giving me...

Thanks Jdraw, doing it your way will work just fine.

I have a query expression that calculates the number of years between 2 dates using DateDiff. Here is the equation as it is: BudgetedHQPCalc: Round(DateDiff("yyyy",[DateHired],[DateTerminated]),1) What I would like this to do, is if the difference is, for example, 1.4, I want the number...

Just to clarify, I should end up with 3 queries, the 3rd query being the one with the running sum?

Alright, so the first query now returns a list of fiscal years for each project. The second query still returns this: FYearExport BudgCost Commit IndContribution 2010 2011 8585643 3843643 4742000 2012 22971165 11539000 11432165 2013 36187262 19223980 16963282 2014...

I can actually get the same (incorrect) results if I have 1 query that looks like this: SELECT DISTINCT Year([DateContractSigned])-IIf([DateContractSigned]<DateSerial(Year([DateContractSigned]),4,1),1,0)+1 AS FYearExport, DSum("[BudgetedCost]","tblProject","Year([DateContractSigned])<=" &...

Thanks for the reply. For the first query I now get a list of fiscal years like this: FYearExport 2010 2011 2012 2013 2014 2015 For the 2nd query, I am still missing a total for the first row. To make it easier to troubleshoot, I only used 1 calculated expression (BudgetedCost). Here is the...

I am trying to create a running total query that aggregates project funding by fiscal year. The fiscal year is calculated based on a date time field that is never null. The totals field comes from 2 different number fields that are either 0 or > 0. The query is going to be linked to by Excel...

I agree with you if I was outputting this data to a report. In my case, I am linking to the final output from Excel, to be used on an external dashboard as a chart data source.

Sorry about that, I knew there was a certain way to present the string, but couldn't remember what it was! I will try out your suggestions and get back to you with any further questions.

Sorry, I should mention that since my first post, I have a duct tape solution where I have a FYear field that is used in the running sum, and an FYearExport field that is simply Fyear+1 to be used for exporting to Excel.

So the first query is this: SELECT tblProject.ProjectID, Sum(tblProject.TECTERRACommitment) AS SumOfTECTERRACommitment, tblLookup_ProgramType.ProgramType, Sum(tblProject.BudgetedCost) AS SumOfBudgetedCost...

I have a table full of projects that has a field for the amount of funding that each project has committed to it. I am trying to create a query that will show a running total of committed funding, grouped by fiscal year. I have already figured out how to calculate the fiscal year using this...

No Joy with the CSV.

I think the problem is that the data is actually stored in a table in Excel. I didnt realize that was the case because there is no easy way to tell. Still quite strange that it would import the data this way.

Field names are ID, Company, Province, Actual Revenue. No special characters.