nested if statements AND formulas

[craw]

i've got a crazy question.. or at least i think so. i'm helping a fellow worker with his DB. he has built a query with about a dozen columns of formulas. there's no table - no query... just the formulas. (and they're nasty nested iifs at that) i'm pretty sure he's going in the wrong direction with this but i don't have the knowledge to tell him why. another problem with this tableless qry is the formulas are waiting for input from a main form. there's also formulas in the query that use the calculated information to calculate. (i told you this was crazy)... so my question is, can you build a query with no table?? a side note, if you just open the query.. access prompts for the inputs that are in the main form.

comments?

 

[Mile-O]

there's no table - no query... just the formulas. (and they're nasty nested iifs at that)

What are they evaluating with these formulas then?

Sounds completely wrong...

 

[craw]

didn't see this reply earlier

this is a raw material selection DB. and in order to select the appropriate material, you input finish material OD/ID info... with this input, this MEGA tableless query runs these formulas... this in turn gives a result that will eventually be fed to another set of formulas.

 

[Mile-O]

I'm sorry but I just don't see how a database can have a query but absolutely no tables.

 

[craw]

i agree... i'm pretty sure that the purpose of queries is to base them off of tables or other queries. my suggestion is that my coworker should go back to the original tables and run the formulas one at a time (or as needed).

thanks for entertaining the question.