Query Help

[Guest]

Hello,

I am trying to have Access automatically delete some rows for a Query that I
created and I cannot figure out how to do it. Here is what I am trying to do:

I am pulling Open Items Records from a Database and some of the individual
open items are also part of a group. So not only is Access pulling the
individual items with in the group, but it is pulling the group total it
self. The group ID numbers are the same and the dollar amounts of the
individual open items are equal to that of the group total.

Am I making any sense? Does anyone have any ideas?

Your help would be greatly appreciated.

Thanks

 

[John W. Vinson]

Hello,

I am trying to have Access automatically delete some rows for a Query that I
created and I cannot figure out how to do it. Here is what I am trying to do:

I am pulling Open Items Records from a Database and some of the individual
open items are also part of a group. So not only is Access pulling the
individual items with in the group, but it is pulling the group total it
self. The group ID numbers are the same and the dollar amounts of the
individual open items are equal to that of the group total.

Am I making any sense? Does anyone have any ideas?

Your help would be greatly appreciated.

Thanks

You can see your database - we cannot. Perhaps you could open the Query in SQL
view, and post a few example records of the data it's returning, and what you
want returned.

Note that you do NOT want to "delete some rows for a Query" - a query is just
a view on the data in your table. Deleting rows from the Query deletes them
from the underlying Table, permanently and irrevokably!

I would guess that you simply need to use a different query, or to change the
criteria on this query, so that it pulls the information that you want to see
and not the information that you don't want.

John W. Vinson [MVP]