On Sun, 14 Mar 2010 15:52:22 GMT, "sys_analyst47 via AccessMonster.com"
u58607@uwe wrote:

and after that i create a subform. Correct me if i am wrong i will create a
query which will generate a table on basis of that i will prepare my contract.
Please tell me how can i make my contract by report because for one customer
there are 12 pages of contract how can i design 12 continuous pages in access
? is it possible

Since I have no idea what's on your contract, all I can say is I Don't Know.
You can put "page break" controls on a Report, so you could put some fields on
the report, a page break, some other controls, and so on. You might have some
complexity because a report is limited to 22" total height, however you can
use a report with multiple subreports to get around this limit.


And just tell me one simple thing .. for amount i kept data type number & in
general i mentioned decimal with 2 digit after point but again in form when i
put a value it's getting round off ?? how can i set this

The default Number size is "Long Integer". Select this field in table design
view and look at the Properties in the lower left. A Long Integer is, by
definition, a whole number.

If the field represents money, don't use a Number datatype at all, use
Currency (oddly, it's a datatype of its own, not a special case of Number).
That will give you four decimals. Currency can be used for any type of number,
not just money values, if four decimal places are appropriate; otherwise you
can use Single (floating point, about 7 digits precision), Double (floating
point, about 14 digits), or Decimal (you pick the scale and precision).

--

John W. Vinson [MVP]