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?

    Yup, that'll work. Thanks. But isn't there a cleaner way for future reference? Yes, I understand the problem with storing the date that way, that's why I'm extracting them now before there are too many of them. My application evolves!!! Thanks...
  4. 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...
  5. G

    Exporting metadata (table field descriptions) with table

    Boy, that's great service! Let me run with this and see how it works out. I have a feeling this is just what I need. Cheers, Gifford
  6. G

    Exporting metadata (table field descriptions) with table

    I have this which does what I want but it only writes the info to the Immediate Window. I can't get it to write to the table "fielddesc" Function retrieve_fld_descriptions() On Error GoTo E_Handle Dim tdf As TableDef Dim fld As Field Dim desc As Variant Dim db As Database...
  7. G

    Exporting metadata (table field descriptions) with table

    thanks, I'm anxiously awaiting!
  8. G

    Exporting metadata (table field descriptions) with table

    Thanks Gromit. You've got it but it's the code to export the field descriptions that I don't understand. I can export a table with all the fields but how do I include the description data with each field? thanks again, gifford
  9. 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...
  10. 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