Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to create a summary overview (table) to display the number of records in each table. The numbers should be updated as the data is filtered. I have five tables: A, B, C, D, E, F. The display should look like this:
A 100
B 5
C 1,150
D 21
E 10
Any suggestions are appreciated.
Frank
Franck,
Do a Listbox with Expression or a simple Table...
Like the attached file.
François
Hi there.
Make sure each of your tables have an unique ID field (you can create one with the AutoNumber() family of functions if it doesn't exists) so you can use count(distinct ID) to find out the number of records on each table.
Kind regards,
Ernesto.
Hi Franck,
Use the systems Fields like $Table and $Rows.
See the attached file to get an example.
Have fun with QV,
François
I can get the count for each table, but how can I display them all together?
Franck,
Do a Listbox with Expression or a simple Table...
Like the attached file.
François
How can I restict the number of tables that are appearing? For example, I might have 10 tables in the model, but only want to show 5.
Also, the number of rows needs to change as the data is being filtered.
Franck,
With the systems fiels, I think you can't restrict (i.e. with set analysis)...
I will search more, but...
Regards,
François
Francois
I think I have a work around. I created an inline table to show the table names that I want to display. I create a chart (straight table) and used a calculated expression to count the key for each table.
It works, but is there a bettter way?
Franck,
Good work !
Have fun with QV,
François