Search results for query: *

ok, i'm on a mission now... have to figure out the Module side of Access. sounds like i may be able to dump all of the queries combined in the module. that would be a much more orderly solution than my plethora of query tables! again, thanks! lex

the queries are very simple. of the nature: (SELECT [] FROM [] WHERE [].[] = ""))*(SELECT [] FROM [] WHERE [].[] = ""))*[]![] BUT i used a series of those for each situation (raw cost of materials and then for total with markup cost) and so the final table pulls on about...

the queries are very simple. of the nature: (SELECT [] FROM [] WHERE [].[] = ""))*(SELECT [] FROM [] WHERE [].[] = ""))*[]![] BUT i used a series of those for each situation (raw cost of materials and then for total with markup cost) and so the final table pulls on about...

ok i understand. is it easy to create a 'make table'? will the table be created dynamically? or would i have to run the query each time? i'm just delving into dbase so thanks for the help! the most difficult thing for me is the mix of SQL and 'Access' within Access (i guess that's Jet). lex

i can't seem to get past this one! i only have 6 fields in this particular query... it does draw on a large collection of other queries because 4 of the fields are user defined and call on a bunch of other previous queries. how do i get around this? should i think about migrating to another...