|
| 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
March 12th, 2006, 01:04 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Parameter Query
I have a query that gets the parameters from a form with a subform, the query
is working ok, it pull up the record, what I need it to do is pull the record plus less than so it can sum all records. This is the parameter that gets the present AutoNo the form is on, I need = then the record the form is on for a report. I tried putting = but get an error. [Forms]![frm01_MainForm]![sfrm_DailyReport]![AutoNo] -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200603/1 
|
|
#2
March 12th, 2006, 05:09 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Parameter Query
what I need it to do is pull the record plus less than so it can sum all
records. This wording is not clear to me. "the record plus less than" Less than what? What kind of field is AutoNo? Are you trying to sum in the query or in the form? "chopper57 via AccessMonster.com" u17099@uwe wrote in message news:5d1eb24c74030@uwe... I have a query that gets the parameters from a form with a subform, the query is working ok, it pull up the record, what I need it to do is pull the record plus less than so it can sum all records. This is the parameter that gets the present AutoNo the form is on, I need = then the record the form is on for a report. I tried putting = but get an error. [Forms]![frm01_MainForm]![sfrm_DailyReport]![AutoNo] -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200603/1
|
|
#3
March 13th, 2006, 07:24 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Parameter Query
I got it to work, I think I just had a space in the
=[Forms]![frm01_MainForm]![sfrm_DailyReport]![AutoNo] I'm just a handyman, no expert! KARL DEWEY wrote: what I need it to do is pull the record plus less than so it can sum all records. This wording is not clear to me. "the record plus less than" Less than what? What kind of field is AutoNo? Are you trying to sum in the query or in the form? I have a query that gets the parameters from a form with a subform, the query is working ok, it pull up the record, what I need it to do is pull the record [quoted text clipped - 5 lines] [Forms]![frm01_MainForm]![sfrm_DailyReport]![AutoNo] http://www.accessmonster.com/Uwe/For...arted/200603/1 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200603/1
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cross tab query construction with Subqueries | Steven Cheng | Running & Setting Up Queries | 7 | February 13th, 2006 06:52 PM |
| Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
| How to use a Access Query that as a parameter into Excel database query | Karen Middleton | Running & Setting Up Queries | 1 | December 13th, 2004 07:54 PM |
| Populate report header field from query parameter | jh | Setting Up & Running Reports | 7 | November 13th, 2004 06:38 AM |
| Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Linear Mode
