Printing a form

[Guest]

Hi there, I have designed a simple form based on a query. I need to be able
to print of all the results of the query and then fax the forms to the
relevant people, however the forms all 'run on' from one another and dont
print one form to a page! I have set the form up as a4 using the rulers in
design mode. it was never this hard in filemaker!

Help

 

[Ofer Cohen]

If the query contain only one record that hold the sum of the field, you can
use DLookUp in the control source of the text field



=DLookUp("[FieldName]","[QueryName]")



If there are few records and you want to sum one of the columns, then use
the DSum function in the control source of the text field



=DSum("[FieldName]","[QueryName]")

 

[Ofer Cohen]

Sorry, wrong post

If the query contain only one record that hold the sum of the field, you can
use DLookUp in the control source of the text field



=DLookUp("[FieldName]","[QueryName]")



If there are few records and you want to sum one of the columns, then use
the DSum function in the control source of the text field



=DSum("[FieldName]","[QueryName]")

Hi there, I have designed a simple form based on a query. I need to be able
to print of all the results of the query and then fax the forms to the
relevant people, however the forms all 'run on' from one another and dont
print one form to a page! I have set the form up as a4 using the rulers in
design mode. it was never this hard in filemaker!

Help

 

[Ofer Cohen]

Sorry, wrong post

If the query contain only one record that hold the sum of the field, you can
use DLookUp in the control source of the text field



=DLookUp("[FieldName]","[QueryName]")



If there are few records and you want to sum one of the columns, then use
the DSum function in the control source of the text field



=DSum("[FieldName]","[QueryName]")

Hi there, I have designed a simple form based on a query. I need to be able
to print of all the results of the query and then fax the forms to the
relevant people, however the forms all 'run on' from one another and dont
print one form to a page! I have set the form up as a4 using the rulers in
design mode. it was never this hard in filemaker!

Help