I have 2 tables and those are the fields I use:
Table Directory : Dirindex, Path
Table Files : Dirindex, FileName, size, UpdateDate
I want to produce a report that gives me all the filename that are there more than once and have the same size and UpdateDate and are bigger then 200K.
I have grouped FileName, UpdateDate and Size.
I have also put these conditions and it works fine :
{Files.Size} > 204800
Count ({Files.UpdateDate}) > 1 and
Count ({Files.Filename}, {Files.Size}) > 1
It produces something like this :
FileName Path Size
Abcd.xls N:\Home\JBaker\dir2\ 123,456
N:\Finance\JBaper\dir2\ 123,456
N:\Home\Jcote\dir1\ 123,456
Bcde.doc N:\IS\NBaker\dir4\ 12,345
Cdef.pdf N:\Home\THanks\Backup\ 23,456
N:\Home\JBaker\dir2\ 23,456
That's what I wanted.
Now I want, With the same conditions, only the files that has at least one path starting with "N:\Home".
Can anybody give me a hint on this one please?
the result would look like this :
FileName Path Size
Abcd.xls N:\Home\JBaker\dir2\ 123,456
N:\Finance\JBaper\dir2\ 123,456
N:\Home\Jcote\dir1\ 123,456
Cdef.pdf N:\Home\THanks\Backup\ 23,456
N:\Home\JBaker\dir2\ 23,456
Thank you
Table Directory : Dirindex, Path
Table Files : Dirindex, FileName, size, UpdateDate
I want to produce a report that gives me all the filename that are there more than once and have the same size and UpdateDate and are bigger then 200K.
I have grouped FileName, UpdateDate and Size.
I have also put these conditions and it works fine :
{Files.Size} > 204800
Count ({Files.UpdateDate}) > 1 and
Count ({Files.Filename}, {Files.Size}) > 1
It produces something like this :
FileName Path Size
Abcd.xls N:\Home\JBaker\dir2\ 123,456
N:\Finance\JBaper\dir2\ 123,456
N:\Home\Jcote\dir1\ 123,456
Bcde.doc N:\IS\NBaker\dir4\ 12,345
Cdef.pdf N:\Home\THanks\Backup\ 23,456
N:\Home\JBaker\dir2\ 23,456
That's what I wanted.
Now I want, With the same conditions, only the files that has at least one path starting with "N:\Home".
Can anybody give me a hint on this one please?
the result would look like this :
FileName Path Size
Abcd.xls N:\Home\JBaker\dir2\ 123,456
N:\Finance\JBaper\dir2\ 123,456
N:\Home\Jcote\dir1\ 123,456
Cdef.pdf N:\Home\THanks\Backup\ 23,456
N:\Home\JBaker\dir2\ 23,456
Thank you