View Full Version : some one help me with this report


reddy
04-25-2005, 11:52 AM
I have a from called invoice in which i give the From_Fiscal_Year which is a number and To_Fiscal_Year and the Project_# of that project for which iam trying to generate the invoice. In this I have a Print Report button when i am trying to print the report i am not able to take the information about the Particular project which i gave in the form, like its billing address which is in the Project table.How do i pull this information.

Billing info must be equal to the billing address in the project table where the project_# in invoice form is equal to Project_# in projects Table.

RichO
04-25-2005, 12:31 PM
Is your invoice form bound to a table?

If so you can base your report on a query that joins the 2 tables on the project# field.