Report of one selected record
- Thread starter Bradd
- Start date
pr2-eugin
Super Moderator
- Local time
- Today, 01:10
- Joined
- Nov 30, 2011
- Messages
- 8,494
I don't really work with reports, but here is a link on how to use Reports : http://office.microsoft.com/en-gb/access-help/create-a-simple-report-HA001230739.aspx
If you can show what you have done, I would be happy to have a look.
If you can show what you have done, I would be happy to have a look.
First, I create a query with only record I need, then create a report in report design, use list box wizard, pick : I want the list box to look up the value in a table or query, then select the filed from the query I created. But the result is many records show up.
pr2-eugin
Super Moderator
- Local time
- Today, 01:10
- Joined
- Nov 30, 2011
- Messages
- 8,494
That is quiet bizarre can you upload a Stripped DB?
How to Upload a Stripped DB.
To create a Sample DB (to be uploaded for other users to examine); please follow the steps..
1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..
Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)
How to Upload a Stripped DB.
To create a Sample DB (to be uploaded for other users to examine); please follow the steps..
1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..
Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)
