Parameter Query

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

 

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

 

[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!

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]