Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Database Software
  6. / Microsoft Access

by WoodyWood on February 10th, 2009

WoodyWood

Question

Help answer this question below.

I have a Report which itself has 3 different Query sub-reports inserted. In each of the sub-reports has input Query field 'Shipment'. Can I link the field in 3 Queries within the main report since so that i need not enter 3 times the same input?

Share:
Other

Answers. 2 helpful answers below.

  • by St. Thomas on February 10th, 2009

    St. Thomas

    I probably shouldn't answer I am not familiar with Access. But, if you were using a bigger database you would create a temp table. The subsequent fields in your form would just be re-displaying the data you already entered. When you click submit it would validate the data and either prompt the user where it finds mistakes or insert the data into the main table.

    • Like
    • Report

    No comments. Post one | Permalink

  • by Brian I on February 10th, 2009

    Brian I

    You should NEVER have to enter the same data more than once. Are you sure you're talking about a report and not a form. If it's a form, hide the two that you don't need to see.

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading I have a Report which itself has 3 different Query sub-reports inserted. In each of the sub-reports has input Query field 'Shipment'. Can I link the field in 3 Queries within the main report since so that i need not enter 3 times the same input?

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Excel 2007 access input query
2001 explorer sport 4wd actuator
Reports and subreport query input from a form
How to give same input in report and subreports

Answerbag

a Demand Media company