By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Create a report from and input form

P: 1
I and a new user of MS Access 2003, and I need help with a report created from a form. I created a form that data is inputed weekly. I created a report to display this data in putting only the last entry from the form in the report by putting Last(field name) in the ControlSource of each field on the report. The report pull the last entry, but it repeats it as many times as I have records in the form. How do I get the report to only show the last entry on the input form once?
Sep 20 '07 #1
Share this Question
Share on Google+
1 Reply


hyperpau
Expert 100+
P: 184
I suggest that you do not use that form to print your report.
create another form where a user can select the week they want a report for, using a combo box.

This form is unbound and supplies a parameter for a query. the combobox in this form is unbound but has its rowsource from the table where you input your weekly entries. Let's say the primary key of each of your entry is WeekID. Then this combo box lists the WeekIDs that user can select.


create a query for the same table where your input weekly entries.
now, put the parameters in that query looking up the primary key field in your form.
In this example, Week ID.
Then on the WeekID field of your query, put this criteria:
=Forms!YourFormName!WeekID

now that it is set up, bind your report to that query.
program your command button to open the report directly.
therefore, whatever is the entry that is currently in your form, that is the only record the parameter query looks up to. then this query passess that to the report without the user ever knowing it. Then since this query only has one record in it, then your report bound to it would then only have one record.


I and a new user of MS Access 2003, and I need help with a report created from a form. I created a form that data is inputed weekly. I created a report to display this data in putting only the last entry from the form in the report by putting Last(field name) in the ControlSource of each field on the report. The report pull the last entry, but it repeats it as many times as I have records in the form. How do I get the report to only show the last entry on the input form once?
Sep 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.