Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

restriction on group : doesn't work!

Status
Not open for further replies.

mlalib

Programmer
Sep 17, 2001
13
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top