A
agent86oz
Hi I have a very basic phone records file which I download and run a
query on. I have a couple of expressions for formating and calculation
to make the data show in minutes. It all looks great until I select
the totals button in the records which gives a row at the bottom of
the query of Total.
If you run across the row each column has a List Box with None, Sum,
Count, Maxinum etc.
The problem is colums which are created with an Expression only have
None or Count.
I find the same issue when trying to create a report.
An example expression is
Total Time Minutes: Format([Total Duration]*1440,"#")
The calculation and format is fine but I loose the option of Sum which
I am looking for.
query on. I have a couple of expressions for formating and calculation
to make the data show in minutes. It all looks great until I select
the totals button in the records which gives a row at the bottom of
the query of Total.
If you run across the row each column has a List Box with None, Sum,
Count, Maxinum etc.
The problem is colums which are created with an Expression only have
None or Count.
I find the same issue when trying to create a report.
An example expression is
Total Time Minutes: Format([Total Duration]*1440,"#")
The calculation and format is fine but I loose the option of Sum which
I am looking for.