Search results

  1. G

    Creating Field Names in a query

    Yes, I would appreciate that. Thanks
  2. G

    Creating Field Names in a query

    Ok, i'll read up on Normalizing. Thanks
  3. 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...
  4. 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...
  5. G

    Entering Time values in an iiF Statement

    That solved the problem. Thanks Alot
  6. G

    Entering Time values in an iiF Statement

    data type is date/time
  7. G

    Entering Time values in an iiF Statement

    Every entry comes back as No when I run the query. The table that GDS Rcvd Time comes from has the field format as hh\:nn This what I entered into the query Field: B4 5PM: IIf([GDS Rcvd Time]<#17:00#,"Yes","No"), when i move to a different field it changes to: B4 5PM: IIf([GDS Rcvd...
  8. 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