Thank You Romy for your concern. I actually wrote a function that builds the SQL query based on user selection. Then i called the function in a button click event which after calling this function redefines an already existing query with the new definition and then displays the results in a subform.
Now my problem is that there is a lot of processing time because my query has three joins. I am working on making my code efficient. I have a sum that i need to calculate based on different costs in the database and then use the same in the query too. So, i am first writing a query to find the sum, declaring as a table and then using table.cost to divide. Is there no other way, meaning, is there a way to save the result of a query in a variable and then use this in another query instead of a join. This might reduce the processing time. Please advice. Thank you very much. florence A smile is the light in your window that tells others that there is a caring, sharing person inside.Keep SMILING. ----- Original Message ---- From: ROMEO IDJAO <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, July 9, 2007 2:03:28 PM Subject: Re: [Access VBA Central] [EMAIL PROTECTED] Hi, Hello this is Romy a pilipino working in Jeddah. For your problem you can use queries to filter the true value then you can display or print the true value.This is the simplest way. Or you can use VB code. Don't hesitate to call me if you can't do it. My mobile 966 502916519. Thanks Beulah Florence <[EMAIL PROTECTED] co.in> wrote: I did not know if I could email to your id, i am sorry if i shouldnt have, but i needed the answer for my question. I have a table "Project". There is a field Project name and some other fields that have a boolean value/check box values. The user needs to have an option of choosing the field that should be queried upon. For example the fields, I am talking abt are: F1, F2, F3, F4. I will have these as the value list for Combo box. And When the user selects one of it, will I be able to display all those project names that have a true value for that particular field. I will be waiting to hear from you. Thank you Florence A smile is the light in your window that tells others that there is a caring, sharing person inside.Keep SMILING. ----- Original Message ---- From: rchlon9 <ritchie9710@ btinternet. com> To: AccessVBACentral@ yahoogroups. com Sent: Thursday, June 28, 2007 3:06:12 PM Subject: [Access VBA Central] Re: Field Level Queries Can you explane your question in a little more detail, i am sure what you are trying to achieve is possible but i need to understand better what exactly you need before advising you more. --- In AccessVBACentral@ yahoogroups. com, Beulah Florence <[EMAIL PROTECTED] .> wrote: > > Can I perform a query using an input from the user as a field on which the query is written? > > It is very urgent. Please respond quickly if anyone can help. > > Florence > > A smile is the light in your window that tells others that there is a caring, sharing person inside.Keep SMILING. > > > > ____________ _________ _________ _________ _________ _________ _ ____________ __ > Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. > http://answers. yahoo.com/ dir/?link= list&sid= 396545433 > > [Non-text portions of this message have been removed] > ____________ _________ _________ _________ _________ _________ _ Got a little couch potato? Check out fun summer activities for kids. http://search. yahoo.com/ search?fr= oni_on_mail& p=summer+ activities+ for+kids& cs=bz [Non-text portions of this message have been removed] ------------ --------- --------- --- Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. [Non-text portions of this message have been removed] ____________________________________________________________________________________ Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 [Non-text portions of this message have been removed]
