Search results

  1. G

    Update table based on cross-tab query

    Hello World, I have: tbl - Trees fld1 - TreeID fld2 - year fld3 - Status fld4 - Comment fld5 - UpdateDate I do a crosstab to look at the status of each tree over the 5-year period (fld 2 can be 1-5): TRANSFORM Sum(Trees.STATUS) AS SumOfSTATUS SELECT Trees.TREEid FROM Trees GROUP BY...
  2. G

    Running sum for time and group?

    Hello, I'm trying to calculate some running sum queries in preparation for some charts on a report. I have: tbl: Spencerdaily fld1:datein fld2:milesdriven fld3:vehiclenumberdaily I am trying to calculate the running sum of milesdriven for each year per vehicle. If I use the following I get...
  3. G

    Wildcard for one OR more digits?

    Hello, I'm trying to use wildcards to filter for records that contain a date somewhere within the string. I'm using Like "*#.##.##*" which works for dates that have a day of the months >10, but what about those under? Well, Like "*#.#.##*" only works for those with the day of month <10. Is...
  4. G

    Exporting metadata (table field descriptions) with table

    Hello everyone, I frequnetly need to export tables for others to use. I export them as .csv files usually and I'd like a way to include what I call metadata in the .csv file. ideally, it would appear on the top of the file before the comma-delimited data actually starts. I can't figure out...
  5. G

    Help exporting table with last updated time stamp???

    Hello everyone, I use the following to export a table with a time stamp but it only gives me the current date. How would I change this to include the date the table was last updated? I see there is a lastupdated property but I can't seem to use it to write the filename. any helpers? please...
Back
Top Bottom