How to create query automatically?

[lwc920418]

Hey guys,

I meet one situation, I have a master table to deal with. In this table, I have all the information about our customers and the information are sorted by multiple fields like location, name, address. One thing that can identify the customer is customer ID. I grouped customers by ID. Like Customer John is customer 1.
Now, I need to group customers by ID, so, I ran a query where the criteria is "1".
However, I need to manually enter 90 times because there are 90 different customers in the table. How can I write a macro or VBA so that they can be done automatically into 90 queries?

Thank you

 

[rzw0wr]

Well something ain't right.

besides wanting 90 queries what is it you are attempting to do?

Dale

 

[lwc920418]

I want to divide the information into pieces. I need all the information about customer 1 - 90. But I want them one by one because I need to send them out to customers one by one, too. I don't want one customer have access to everyone's data.

 

[way2bord]

1 query + 1 dynamic filter = 90 different outputs.

Make a form.
Add a combobox to it.
Populate the combobox with all customer numbers.

Add the following criteria to your Query under CustomerNumbers field.

Forms!YourFormName!ComboBox1

 

[lwc920418]

The purpose is to generate the query automatically and send specific query file to specific customer email address. The difficult part is to get the information AUTOMATICALLY.
If you want to talk this project through phone with me, we can do that.

Thnaks

 

[Mihail]

And you send to your customers a query ? How ?