subdata sheet question

jburns

New member
Local time
Today, 05:24
Joined
Feb 8, 2008
Messages
1
Hello!

This is my first time here. I am trying to perform a operation but not sure how to do it. Let me try to explain.

I have Access 2000 on my Vista computer and I have a Access database with patient medical records listed in multiple columns. I can sort them with no problems BUT what I need to do is go into the subdata sheet of each patient and do a sort out on one of the columns. My question is, is there a way that I can sort a specific column in my subdata sheet either by the checked box or no checked box? What I am having to do is go through each patient and delete each session that does not have a check mark and that is very time consuming. There has to be a quicker way of sorting and deleting what I need from that column.

I hope I explained myself ok...

Jason
 
it would make more sense (and would be more accurate) to create a delete query to accomplish the task.

I would recommend making a backup of your data before messing with delete queries though.
 
It would make even more sense to avoid using subdatasheets - they casue more trouble than they are worth. Use a related table instead.
 

Users who are viewing this thread

Back
Top Bottom