Search results

  1. A

    Less Than IIF Query

    any help guys?
  2. A

    Less Than IIF Query

    got the above 1 co to work but still don't know about getting the #1 co to work make 2 queries Sub CO Select Sub2Q SELECT [Sub CO All Q].[Value $], [Sub CO All Q].[CO Number], [Sub CO All Q].Subcontractor FROM [Sub CO All Q] WHERE ((([Sub CO All Q].Subcontractor)=[forms]![Main sub co...
  3. A

    Drop Down Menu in a Parameter Box?

    just saying that it is possible
  4. A

    Drop Down Menu in a Parameter Box?

    you should still be able to do it in a table if you prefer to... go to table design view... lookup tab... display control change to list box/combo box
  5. A

    Less Than IIF Query

    trying to run a query to generate previous CO Sum values. Wrote the query below to do this and it doesn't work... please check it out and let me know what I did wrong. SELECT Sum(IIf([forms]![Main sub co Fm].[combo27]=1,0,[value $])) AS [Previous CO] FROM [Sub CO All Q] WHERE ((([Sub CO All...
  6. A

    Grouping multiple rows

    i'll check it out looks prettier lol (no comma at the end on the list) but still comes up with an error
  7. A

    Grouping multiple rows

    there is one thing... when there isn't a circuit in the raceway it comes up with an error... is there a way to keep this from happening? like when blank return blank or something?
  8. A

    Grouping multiple rows

    wow... i'm special... lol... i must have done something wrong... i redid everything and it worked... thanks so much
  9. A

    Grouping multiple rows

    i renamed the module Concat so you knew which one was the one you made... its somethin different in mine...
  10. A

    Grouping multiple rows

    i remember i deleted it to make it fit... to get that query i... 1. ran the "raceway circuit split" module 2. made a query "raceway package" with this sql SELECT Packages.ID, Packages.Raceway, Packages.Circuit, Circuit.Package FROM Packages INNER JOIN Circuit ON Packages.Circuit =...
  11. A

    Grouping multiple rows

    shoot i forgot it... hold on a second lol
  12. A

    Grouping multiple rows

    i got it down some more...
  13. A

    Grouping multiple rows

    i got it down to 3... well 2.53
  14. A

    Grouping multiple rows

    i have a help db... its 3MB it didn't work correctly... error
  15. A

    Grouping multiple rows

    wat should i name the query...
  16. A

    Grouping multiple rows

    hmm... i don understand any of that lol... i made a mod and inserted the data... no error but i couldn't see wat it did anywhere... where should i look?
  17. A

    Grouping multiple rows

    pivot table... hmm...
  18. A

    Grouping multiple rows

    the second one looks like what i need... but its a little complex for me to edit myself... would you be able to help me out?
  19. A

    Grouping multiple rows

    i don understand how they work...
  20. A

    Grouping multiple rows

    What i am trying to do is group the raceways and have one row for each raceway... do this by grouping the packages and seperating them by ", " is this possible in a query or do i have to use a module? so i want it to look like this Raceway Package 1EECBX01 1APC-01, 1BMC-01, 1CCC-01...
Back
Top Bottom