If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query Help!!
Hi!
I am trying to create a query that uses the values I have in a form as the criteria. THe form has three tables and you can select which fields you want from each of the three tables. Ultimately you are left with three fields that are going to be compared (there values from different budgets). I could do all of the math stuff once I get the three fields to show up in the select query that I cannot set up right now. If anyone can help me it would be greatly appreciated. Thanks in advance for your time. ~Brian |
#2
|
|||
|
|||
Query Help!!
To use a form field as criteria you would put:
Forms!YourFormName!YourFormFieldName in the criteria of your query field. Obviously you need to substitute the correct values. Hope that helps! |
#3
|
|||
|
|||
Query Help!!
I have tried putting criteria in the query but I still get no results.
I am still not sure which field to put in the query if I am trying to use the field selected in the form combo boxes. SHould I be doing something else Like a look up or open table macro?? I am just lost at this point. Thanks for the response! ~Brian Jeff L wrote: To use a form field as criteria you would put: Forms!YourFormName!YourFormFieldName in the criteria of your query field. Obviously you need to substitute the correct values. Hope that helps! |
#4
|
|||
|
|||
Query Help!!
You use the name of the combobox on your form, whatever you have called
it. If you called it MyCombo then you would use that in the criteria. Forms!YourFormName!MyCombo Hope that makes better sense. BrianH wrote: I have tried putting criteria in the query but I still get no results. I am still not sure which field to put in the query if I am trying to use the field selected in the form combo boxes. SHould I be doing something else Like a look up or open table macro?? I am just lost at this point. Thanks for the response! ~Brian Jeff L wrote: To use a form field as criteria you would put: Forms!YourFormName!YourFormFieldName in the criteria of your query field. Obviously you need to substitute the correct values. Hope that helps! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
SQL query showing diff between actual and budget | Bon | Running & Setting Up Queries | 3 | August 25th, 2005 12:07 PM |
Nested in-line Query | laura | Running & Setting Up Queries | 0 | February 11th, 2005 12:17 AM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |