Numbering Entries in a Report or Form
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a table that allows for unlimited entries, but it needs to have at least 2 entries per Person (already connected relationally in a one-to-many). I need a calculated control for the form that can state how many more entries the Person needs by counting the number of entries that are already in the table.
For example, PersonA has 1 entry and the control would state that 1 more is needed. However, Person B has 3 entries and the control would simply be blank.
I plan to use the control in both a form and also a report.
This code works fine when used as an unbound field on a form, but I keep getting an #Error when displaying it on a Report. My intent is to have the historical entries display on a report as well.
The report source is a query, so it is only returning the last entry made. Is there a better way to save historical entries with a date/time stamp for a record?
Relationships: Shows the three tables and how they relate
Report Layout: Shows how I have done up the report in design layout
Report Results: Shows the extra values that I do not want. Ex. This is the report for NCR 19 but I am getting information for NCR 20 and 21 in the Problem Section and NCR Employee Section
Data Entry Form: Just shows the data entry for that feeds entries into all three tables.
1. ABC Company 100
2. DEF Company 90
3. GHI Company 80
How can I number each line on the form WITHOUT writing the results of the query to a temporary table. I want to avoid temporary tables as I want the user to update tick boxes on this form based on scores.
How do I get the form to count the number of rows and assign numbering. Is it something I can assign within the query rather than the form?
When talking about Microsoft Access, auto numbering should only be used when you want to create a primary key, but don't want it to have any real significance to it, other than the fact that it is unique.
The difficulty I have is that there are 2 tables involved. One creates a auto batch number for a group of entries the other an auto number for each of the group entries. There is of course common data between the two tables and the link is an operator number.
Searching the lounge and the web the best I can work out is not to include the auto number fields in theappend query is there anything else I should know or do.
My question is; is there a way to have the page numbering start over with each new record?
For example record 1 may have Page 1 of 2 and Page 2 of 2. while record 2 may have Page 1 of 3, Page 2 of 3 and Page 3 of 3, record 3 may have just Page 1 of 1, etc.
The entries open in DataSheet view in chronological - input - order. Is there a way to set a sorting parameter within the 'DoCmd' so all entries from each volunteer can be grouped together?