Recent content by AccidentalFate

any help guys?

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...

just saying that it is possible

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

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...

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

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?

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

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

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 =...

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

i got it down some more...

i got it down to 3... well 2.53

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

wat should i name the query...