Printing a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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]")
 
Sorry, wrong post


Ofer Cohen said:
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]")



misterchase said:
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
Click to expand...
Click to expand...
 
Sorry, wrong post


Ofer Cohen said:
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]")



misterchase said:
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
Click to expand...
Click to expand...
 
Back
Top