Accrosed
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 2 articles for 0.303 sec
Lord Kelvan, I can't hardcode a switch for those statuses. The example data I gave you is just a small set of the table I am working with. There are way too many different ENDSTATCD values for me to hard code. The ID number is the only control source that can be used to match. Because the BEGDATTIM occurs a little after the ENDDATTIM chronologically speaking (but not necessarily at     

Group: microsoft.public.access.queries · Group Profile · Search for Accrosed in microsoft.public.access.queries
Author: Nick
Date: Aug 27, 2008 05:38

mmm i tested your query with some test data based on what you gave me and the problem isnt what you think your query works fine for all records that are not the first group id endwrktype endstatcd begdattim enddattim 1 app SCANNED 08:00 a.m. 08:15 a.m. 1 app ISSUED 08:17 a.m. 08:30 a.m. 1 app PASSED 08:45 a.m. 08:55 a.m. 2 app
Show full article (3.60Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Accrosed in microsoft.public.access.queries
Author: Lord Kelvan
Date: Aug 26, 2008 15:52

Show full article (2.58Kb) · Show article thread