Hi to all,
what is the code equivalent for
if ([FieldA] < [StartDate]) then
[FieldB].value=0
end if
[StarDate] is a Date parameter which i entered when the report is created
[FieldA] is a Date field
[FieldB] is a Number field
i want to insert this in the code builder to run before the report is created, so that it changes the results showed
Can you explain more fully?
What's Code Builder?
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
in Design View for a Report u can select to biuld an event an have 3 options:
Macro Builder
Expression
Code Builder
Code Builder looks like VBE and if this would have been Excel i would know where to start from, but being access ...
Here's a .jpg to help explain my problem better
the Report is supposed to show the Total Income for the period entered. My problem is with the Addendum (Act aditional in the report), since it's linked to the Contract and i need to show the contract info for that addendum, but i also have to show contracts info.
The problems appears with addendum for 2012 which have a contract done in 2011, because the info from 2011 appears in the report and affect the sums.
That is why i was trying to resolve this by code.
Can you post a sample database showing how it is now and how you expect it to look? Please make it compatible with Access 03.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks