Search results

  1. G

    Creating Field Names in a query

    Hi again, I am hoping to create a field name in a query that will change every month. Right now the filed name is qryTechQuintileMonth-7.am_quintile. this designates that the data is for October 2012. There are 6 other fields named similarly for Nov 2012 through April 2013. Is there a way to...
  2. G

    Counting Field Results in a query

    I am trying to build a calculated field that counts the number of times the letter E appears in 8 fields. the query currently looks like the attachment. I need to have one more field , lets call it NetFlags, that is the number of times the Letter E is in the row for each Technician. So for...
  3. G

    Entering Time values in an iiF Statement

    I'm creating a Select Query and want to create a field that uses another existing field in the query. The existing fiels is [GDS Rcvd Time] and is formatted as date/time. The new field I want to create will be either "Yes" or "No" based on the result of the following: If [GDS Rcvd Time] is...
Back
Top Bottom