Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: prompt for start time

    I am having issues using a field that i create in a query when it involves an aggregate function. For example, I have a query with starttime as a field field1:[starttime]. In the next field I try and use field2:[field1]. I get a promt for [field1]. When i click OK the query works but I would like to avoid this error. If I do not group the query I do not get this error. Also, i checked my settings and the query does read left to right so the field1 should be in existance before field2 is run.
    Any ideas?
    Thanks-
    Elizabeth

  2. #2
    Join Date
    Sep 2004
    Location
    Reston, VA
    Posts
    86
    You're getting that error because of the fact that you're grouping on a field that uses an alias. Instead of using "field2:[field1]" use "field2:[starttime]" - replace your alias with the original field names from the table, or the formula you used to calculate that alias. If you group on that it will 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
  •