Create A Form Based On User Input

[MrJCM]

Hello and please accept my apology as I am sure this has been covered many times.

I would like to have a form where a user selects specific criteria from a list of options. For example; I have a table which has the following fields:

Department
List of all expenditures
Contract Date

On this form I would like the user to select a date range, (OR specific month) and department. Upon execution I'd like the form to display the total expenditure (not a list of each) by department for the requested period.

Additionally, I'd also like it to display the total expenditure by month, i.e., total for Jan, Feb, Mar etc.

Lastly, I'd like the user to be able to print this form.

I hope that I was able to express my dilemma clearly.

Thanks in advance.

 

[TheAceMan1]

How are ya MrJCM . . .

Have a look here Fundamentals of Relational Database Design

The one table you presented is not normalized ...

[blue]Your Thoughts? ...[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Andrzejek]

It looks to me that – instead of a Form to be printed – you need a simple Report.

You choose your criteria: Department from drop-down list, date(s) from some kind of calendar control, and you create a report to be viewed or printed.


Have fun.

---- Andy

 

[TheAceMan1]

Howdy Andrzejek . . .

I never print forms ... only reports. Either way, I believe [blue]MrJCM[/blue] is interested in viewing the filtered data ,,, even before printing.

Anyway it doesn't appear as if they'll return to this thread.

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[MrJCM]

Hi Guys and thanks for the assist.

AceMan, I do not have a lot of time during the day to work on this, so I apologize for not being more timely. You are correct in assuming that it is the filter I needed. Anyway, I was able to achieve something similar as a workaround.

Many thanks for your time and willingness to help those of us that are less experienced.

It is a great service you provide.