Reports

  • Thread starter Complete or Incomplete
  • Start date
C

Complete or Incomplete

How can i seperate a form Tab created in reports where it can be ticked as
Incomplete and Complete. And run a report with both seperate information?
 
J

John Vinson

How can i seperate a form Tab created in reports where it can be ticked as
Incomplete and Complete. And run a report with both seperate information?
Click to expand...

I'm sorry, this question assumes that we have a great deal more
knowledge of your application than is visible here.

A Form Tab is just a screen-realestate conservation tool. You can't
"separate a form Tab created in reports" - and I'm not sure what that
means.

What is the structure of your table or tables? Where is the "complete
or incomplete" tick stored? What "separate information" do you want to
see?

John W. Vinson[MVP]
 
C

Complete or Incomplete

Hi,

The Complete or Incomplete" tick is stored as an option in FORMS.

I then created a report by using Wizard and was given an option to choose
the TAB(Titles) from the FORM i created.

I choose Complete or Incomplete as one of the headers in the report. But
when i print/preview the report it come with both Complete and Incomplete
results.

I would like to now be able to create two reports where one will have the
Complete only and Incomplete only.

How can I seperate these two from each other?

Thank you

Thank you for your response
 
J

John Vinson

Hi,

The Complete or Incomplete" tick is stored as an option in FORMS.
Click to expand...

I'm sorry, but you are mistaken.

Forms ARE JUST WINDOWS. Data is *not* stored in Forms. Data is stored
in Tables.
I then created a report by using Wizard and was given an option to choose
the TAB(Titles) from the FORM i created.

I choose Complete or Incomplete as one of the headers in the report. But
when i print/preview the report it come with both Complete and Incomplete
results.

I would like to now be able to create two reports where one will have the
Complete only and Incomplete only.

How can I seperate these two from each other?
Click to expand...

You need to realise that your Report is based on data in a Table - and
that the wizards are not perfect, very far from it in fact!

I'm assuming (perhaps incorrectly) that you have *something* in your
Table that indicates whether a record is Complete or Incomplete. Since
I cannot see your tables, and you chose not to post any information
about your tables, I don't know what that might be.

You can base your Report on a Query selecting just Complete, or just
Incomplete, records. If you wish to modifiy the wizard-generated
report, open it in Design view; view its Properties; and click the ...
icon by the "Record Source" property, the first one on the Data tab.
This will open a Query Design window (perhaps asking if you want to
convert the table to a query - say yes); you can then adjust the query
using criteria to select the records that you want to display.

John W. Vinson[MVP]
 
Top