grouping data

V

violet

i have a list of data which actually have duplicates, thus i will like to use
group by to group them together to prevent the duplicates. i'm grouping them
according to the id available. however, some data does not contain id num,so
when i do grp by, all data that does not have id will become one records. is
that anyway i can sort my data where duplicates records will become one
record and for those without id, it will just remain as what it is.
 
V

violet

but then i neeed the data that has no id also. i have try using 2 queries,
one is to return data that contain null id and one is for the rest of the
data that contain id. however, i do not know how to combine these 2 queries
into 1 table/queries so that i can use all these data for other queries.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
Copy previous record into form field 0
Drag without incrementing 2
Cannot import CSV file into ACCESS 1
Making id cards 1
Not able to enter Chinese 4 byte characters (GB18030)in MS Access 0
Transpose columns to rows in groups 4
How to shade groups of rows in excel. 1

Top