Thank you for taking the time to report an issue.
What's wrong... Please write below.
I want to use these in a form :
Date Field: Date()
Date Of test: "Date Field"
Date of Next Test:"Date of Test" + 180 days
Days Overdue: Date() -"Date of Next Test"
I've tried to work it out using expressions, but don't think I'm grasping the syntax.I come from the simple world of the Approach database where you can create calculated fields in the table.
This works OK until the end date exceeds 08/10/2010. The value isn't returned when the end date is 08/11/2010 or higher.
My goal is to create a representation of when certain dates have been selected in a timeline.
ie client number, Kg (which is the weight), date, etc.
I am trying to create a query that will let me select a date range (which I have the entry for) and then list each client with a total Kg for the date range entered.
How or where can I enter the sum function
I have a form with code on the On Current event that runs a function to do some calculations with the data in fields on the form and writing the results back into fields on the form.
The calculations relay on the date, so data of the diffrent records are always "out of date" until the user goes to a spesific record which means the On Current event procudure will then update the spesific record.
Now if the User want to view a list of all records with their respected up to date fields, it means he has to run through all the records to make sure they are up to date.
Now I have automated this to do a run-through before the query opens, but the result is slow, especially with Users who have say 500 records and where the BE is on their server.
With 500 records it may take up to 4 minutes
When the query is executed I receive an error that I ‘tried to execute a query that does not include the specified expression *** as part of an aggregate function. *** is the calculated field in the query. The help button reveals this is also known as Error 3122.
I thought it would be straightforward to select this data by a date range and perform the calculations.
Example - the split could be Company A - 25%, Company B - 25%, Company C - 50%. There are many different combinations of splits to choose from.
Total cost (to date) could be $125,000.and I need to take the above percentages and calculate the cost distribution across the participating companies. Is this possible?
In my case - I will have many different split scenarios which need to be "looked up", percentages passed, and calculations done