Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    19

    Unanswered: Help With Queries

    Hi i want to know if its possible to combined two Fields together. Since i have a field for Minutes and another one for seconds. Since I need to build a queries for athletes who have a time less then 10min and 30seconds. Cheers

  2. #2
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    The real question I suspect is;

    Why have you made more work for yourself?

    Time entries in HH:mm:ss are simplistic using a simple mask AND if you need to perform calculations, as I would have thought you would with and Athletes timings then this protocol would be ideal. I think you need a re-think of the dtat punch process

    However, it is possible to combine

    Gar

  3. #3
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by ccastell89
    Hi i want to know if its possible to combined two Fields together. Since i have a field for Minutes and another one for seconds. Since I need to build a queries for athletes who have a time less then 10min and 30seconds. Cheers

    It's easy, you should just have to make the query and after you add the 'min' and 'secs' fields from your field list into the query, you can look at the SQL view of the query and select the operators just like back in school with "<", ">", "=" , "<>". Things like that. Let use know if you can't figure it out and post your code from y our SQL View of your query, we'll give you some help on what to do to make it work.

Posting Permissions

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