using multiple tables in a form

[leewisener]

I want to create a form with an initial data source provided then for example list how many accounts were outstanding today, yesterday and so on....

Each day's data is in a seperate table, I thought about simply adding the data from each day to 1 table but then thought,no leave it as multiple.

I thought I could enter this into the form

=Count([today]![Account Number])

today = table
The account numbers are counted giving a total.

Then in the same form I could put

=Count([200806]![Account Number])

200806 being the table for that date

and so on.....

Not working though.

I am now thinking that perhaps joining everything together in 1 table would be better

any ideas?

 

[Pampers]

I would start to put all the days data into 1 table.

Pampers
Just back from holiday...
that may it explain it.