Parameter Query

  • Thread starter chopper57 via AccessMonster.com
  • Start date
C

chopper57 via AccessMonster.com

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]
 
K

KARL DEWEY

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?
 
C

chopper57 via AccessMonster.com

I got it to work, I think I just had a space in there:

<=[Forms]![frm01_MainForm]![sfrm_DailyReport]![AutoNo]

I'm just a handyman, no expert!



KARL said:
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
Click to expand...
[quoted text clipped - 5 lines]
[Forms]![frm01_MainForm]![sfrm_DailyReport]![AutoNo]
Click to expand...
Click to expand...
 
Top