If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reports
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? |
#3
|
|||
|
|||
Reports
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 "John Vinson" wrote: On Tue, 7 Feb 2006 20:04:26 -0800, "Complete or Incomplete" Complete or wrote: 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? 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] |
#4
|
|||
|
|||
Reports
On Tue, 7 Feb 2006 21:40:26 -0800, "Complete or Incomplete"
wrote: Hi, The Complete or Incomplete" tick is stored as an option in FORMS. 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? 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Emailing PDF reports from Access | CraigMc | General Discussion | 6 | October 11th, 2007 12:52 AM |
Report Filter | ACase | Setting Up & Running Reports | 3 | October 27th, 2005 08:51 PM |
Some users cannot run reports | Frank | Setting Up & Running Reports | 11 | October 22nd, 2005 03:46 AM |
Print a series of reports based on a single date and a series of numbers | Bill R via AccessMonster.com | Setting Up & Running Reports | 1 | September 9th, 2005 12:53 AM |
REPOST: Maintaining Page Numbers with multiple reports. | Robin Chapple | Setting Up & Running Reports | 1 | August 5th, 2005 06:53 AM |