Results 1 to 13 of 13
  1. 01-01-2019, 10:29 PM #1
    MLogue9
    MLogue9 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2019
    Posts
    22

    Question Using AND and BETWEEN - is it legal?

    This seems to ignore the second clause of the where statement "AND directoryShort = '14'" instead I get all the file sizes summed. I only want when shortdirectory is 14 and of course dated is in range of 1-5.

    "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = '14';"
    Reply With Quote Reply With Quote
  2. 01-01-2019, 10:41 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    That looks okay, presuming both fields are text.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 01-01-2019, 10:43 PM #3
    MLogue9
    MLogue9 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2019
    Posts
    22
    Yeah I know it's legal. Probably a section of VBA code isn't parsing as I wish.
    Reply With Quote Reply With Quote
  4. 01-01-2019, 10:53 PM #4
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    Is the field name shortdirectory or directoryShort?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  5. 01-01-2019, 11:18 PM #5
    MLogue9
    MLogue9 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2019
    Posts
    22

    Bwtween and AND returns what seems to be overlapping resiults

    June7 - you made me look. It's all directoryShort.

    Here is the form with year 2014 populated. The total for that year is 146GB, not much. However day ranges add up to way over that.

    Click image for larger version.  Name: clipmgr.jpg  Views: 12  Size: 69.4 KB  ID: 36753Here is the whole ugly code... it is a matrix of sorts as you'll see. It is coming up with values about 5 times higher for each segment of 1-5, 6-10, etc. These are days.

    The most pertinent line is: d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    That means day1-5 field on a form adds to itself the sum of filenames in table sclips that have directory name of /14/ AND modify date days 1-5. Rounded.
    Most lvalues here are fields on a form.

    Code:
    Private Sub cmdSubtotals_Click()
txtCFree = Round(getFreeSpace("C:\", 3), 0) & "GB"
txtgFree = Round(getFreeSpace("G:\", 3), 0) & "GB"
CstrSQL = "SELECT sum(fileSize) FROM tClips WHERE directory LIKE 'C:\%'"
GstrSQL = "SELECT sum(fileSize) FROM tClips WHERE directory LIKE 'G:\%'"
txtUsedC = Round(tableRead("DirectSQL", CstrSQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
txtUsedG = Round(tableRead("DirectSQL", GstrSQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
size14SQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = '14'"
size14 = Round(tableRead("DirectSQL", size14SQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
size15SQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = '15'"
size15 = Round(tableRead("DirectSQL", size15SQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
size16SQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = '16'"
size16 = Round(tableRead("DirectSQL", size16SQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
size17SQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = '17'"
size17 = Round(tableRead("DirectSQL", size17SQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
size18SQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = '18'"
size18 = Round(tableRead("DirectSQL", size18SQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
size19SQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = '19'"
size19 = Round(tableRead("DirectSQL", size19SQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
sizenewSQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = 'New'"
sizeNew = Round(tableRead("DirectSQL", sizenewSQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
sizeweekSQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = 'week'"
sizeWeek = Round(tableRead("DirectSQL", sizeweekSQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
sizeancientSQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = 'archiveAncient'"
sizeAncient = Round(tableRead("DirectSQL", sizeancientSQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
sizeSelectedSQL = "SELECT sum(fileSize) FROM tClips WHERE directory like '%selected%'"
sizeSelected = Round(tableRead("DirectSQL", sizeSelectedSQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
strSQL = "SELECT sum(fileSize) FROM tClips WHERE directoryShort = 'biweek'"
sizeBiWeek = Round(tableRead("DirectSQL", strSQL, 0, 0, 0) / 1024 ^ 3, 0) & "GB"
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = '14';"
no14 = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = '15';"
no15 = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = '16';"
no16 = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = '17';"
no17 = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = '18';"
no18 = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = '19';"
no19 = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directory LIKE '%selected%';"
noSelected = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = 'new';"
noNew = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = 'week';"
noWeek = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = 'biweek';"
noBiWeek = tableRead("DirectSQL", strSQL, 0, 0, 0)
strSQL = "SELECT count(fileSize) from tclips WHERE directoryShort = 'archiveAncient';"
noAncient = tableRead("DirectSQL", strSQL, 0, 0, 0)
cam1 = 0
cam2 = 0
cam3 = 0
cam4 = 0
c151 = 0
c152 = 0
c153 = 0
c154 = 0
c155 = 0
c156 = 0
c157 = 0
c158 = 0
d15 = 0
d610 = 0
d1115 = 0
d1620 = 0
d2125 = 0
d2631 = 0

If (chk14 = True) Then
    cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = '14'", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = '14';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    End If
If (chk15 = True) Then
    cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = '15';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
  
    End If
If (chk16 = True) Then
    cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
       d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2531)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = '16';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
 
    
    End If
If (chk17 = True) Then
    cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
       d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = '17';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
 
    End If
    If (chk18 = True) Then
    cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
        d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = '18';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    End If
If (chk19 = True) Then
    cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
        d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = '19';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    End If
If (chkSelected = True) Then
    cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = 'selected';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    End If
If (chkAncient = True) Then
cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
   
  d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = 'archiveAncient';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
  
    End If
If (chkWeek = True) Then
cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
      d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = 'week';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
  
    End If
If (chkBiWeek = True) Then
cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = 'biweek';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
  
    End If
If (chkNew = True) Then
cam1 = oNum2(cam1) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam1%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam2 = oNum2(cam2) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam2%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam3 = oNum2(cam3) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam3%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    cam4 = oNum2(cam4) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'cam4%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
    c151 = oNum2(c151) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c151%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c152 = oNum2(c152) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c152%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c153 = oNum2(c153) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c153%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c154 = oNum2(c154) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c154%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c155 = oNum2(c155) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c155%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c156 = oNum2(c156) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c156%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c157 = oNum2(c157) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c157%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    c158 = oNum2(c158) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE filename LIKE 'c158%' AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
    
d15 = oNum2(Nz(d15)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '1' AND '5') AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d610 = oNum2(Nz(d610)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '6' AND '10') AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1115 = oNum2(Nz(d1115)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '11' AND '15') AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d1620 = oNum2(Nz(d1620)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '16' AND '20') AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2125 = oNum2(Nz(d2125)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '21' AND '25') AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
d2631 = oNum2(Nz(d2631)) + Round(tableRead("DirectSQL", "SELECT SUM(filesize) FROM tClips WHERE (dateDD BETWEEN '26' AND '31') AND directoryShort = 'new';", 0, 0, 0) / 1024 ^ 3, 0) & " GB"
  
    End If
End Sub
    Reply With Quote Reply With Quote
  6. 01-01-2019, 11:18 PM #6
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Can you attach a sample db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  7. 01-01-2019, 11:53 PM #7
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    I see % character used as wildcard. Have you set db to use ANSI-92 query mode? Is the backend an SQL db?

    Equivalent standard wildcard character in Access is *.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  8. 01-02-2019, 12:08 AM #8
    MLogue9
    MLogue9 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2019
    Posts
    22
    No it isn't a SQL db nor is it ANSI-92. I saw online to use % and forgot to use the stars.
    Reply With Quote Reply With Quote
  9. 01-02-2019, 12:19 AM #9
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    I'm confused. The failing SQL has no wildcards.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  10. 01-02-2019, 12:34 AM #10
    MLogue9
    MLogue9 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2019
    Posts
    22
    It is a big database in terms of "width". The tclips is wide and long though. 60MB isn't too bad though compressed. All the concern is on tclips and fclips. newmod module has a few scattered functions like tableread (which reads a single specified row off a table, opens and closes the connection, easy to invoke) and onum2 (only numbers, how I get "64GB" to sum to 50.) OK my upload is failing as I wait and type. My goal is to be able to move and delete odd ranges such as interlaced days 6-31 on every month with one operation. Clearly I want it functioning well-very well, before I give it power to delete videos.

    Well, NO way can I get this compressed to just 2MB. I just read the thing that explained why the upload failed.
    Reply With Quote Reply With Quote
  11. 01-02-2019, 12:37 AM #11
    MLogue9
    MLogue9 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2019
    Posts
    22
    I'm very confused then. They do sum to eachother, the fields/textboxes but only with multiple checkboxes checked; it is zeroed out at init. A simple if statement regulates which section of SQLs are ran to add to the fields/textboxes.
    Reply With Quote Reply With Quote
  12. 01-02-2019, 12:47 AM #12
    MLogue9
    MLogue9 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2019
    Posts
    22
    One pattern emerges: The maximum of each range does not exceed the total, but often approaches or matches it.
    Reply With Quote Reply With Quote
  13. 01-02-2019, 12:53 AM #13
    MLogue9
    MLogue9 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2019
    Posts
    22
    Solved. The data type for the field dated was TEXT. I changed it to number and removed the single quotes and viola! That part now works.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Setting Report to Print on Legal Size Paper
    By najjan in forum Reports
    Replies: 1
    Last Post: 05-26-2016, 09:31 PM
  2. Is this possible and legal?
    By cvegas in forum Access
    Replies: 1
    Last Post: 08-09-2011, 02:19 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums