When trying to import a SP it fails and says 'must declare the variables @day @month @year'. If I change these to @Day, @Month @Year then it's ok. However this procedure is still giving me problems that lead me to believe it is case sensitive. I had changed the collation of the db to...
does anyone know how to select a record based on the value of a previous record in the table.
So if records where numbered 1,2,3,4,5,..... can I select a field for record 5 if the value of that field for record 4 is a certain value.
EXAMPLE
No. Name
1 river
2 tree
3 house
Show...
Does anyone know if it is possible and if so how to change the start date for the YearToDate function.
Say for example the year started on 1/03/02 how would one include any yearToDate records but only from 01/03/02 e.g. for a financial year?
The formula is
Increase = {@RunningSumTo}/{@RunningSumFrom}
RunningSumTo =
WhilePrintingRecords;
Global NumberVar RunningSumTo := RunningSumTo + {@YearToAmount};
RunningSumFrom =
WhilePrintingRecords;
Global NumberVar RunningSumFrom := RunningSumFrom + {@YearFromAmount};
I have been able...
I have a field called increase which is from a formula base on one formula over another. (i.e. Amount 1/Amount 2).
This is placed in the group footer. How can I only show records where the increase is great than 10.
The formula is not an option in the select expert.
Well boys and girls finally the answer to how make your VBDocuments works on machines conected in a intranet or internet is to simply just sign yor .cabs files!
how do that well.. write me for details
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.