G
Gerhard Weiss
When we add on new clients we have to do data conversions.
I normally importing the data into Access then use
the Queries Groupby feature to see the number of different
values in a column.
i.e. I might have a Class field and the results would be
Cls Count
A 30
B 25
F 50
Right now this takes a lot of clicks to manually analyze all
the fields in one table.
I am looking to automate this process a little by having one
Form that will allow you to pick a Table and then a Field
inside of that table. It would then execute the Groupby query
showing the values in a the field plus a count (the number of
time it shows up in the field.)
I have to believe lots of other people use Access in a similar
fashion and that this code or Form should be available
somewhere out their on the net. I just do not know where to
look. Any help would me much appreciated.
Thanks
I normally importing the data into Access then use
the Queries Groupby feature to see the number of different
values in a column.
i.e. I might have a Class field and the results would be
Cls Count
A 30
B 25
F 50
Right now this takes a lot of clicks to manually analyze all
the fields in one table.
I am looking to automate this process a little by having one
Form that will allow you to pick a Table and then a Field
inside of that table. It would then execute the Groupby query
showing the values in a the field plus a count (the number of
time it shows up in the field.)
I have to believe lots of other people use Access in a similar
fashion and that this code or Form should be available
somewhere out their on the net. I just do not know where to
look. Any help would me much appreciated.
Thanks