Multiple Criteria for Sum Query

[rjv888]

Hello Gurus of Access,

I am fairly new to access, so please be patient. I am, however, familiar with VBA and excel if that helps.

In my file, "BernhardMechanical", there is a table titled "Raw Data". And if you couldn't guess, it contains raw data imported from some other software. I am trying to sum the values of the "Quantity" field, but only after it has been filtered by a desired "Job" field, "System" field, and "Item Type" field. The "Item Type" I am interested in particular is "Pipe".

Ideally, I would like to choose what Job and System I desire before the query or other method is run. I tried using parameters, but I am forced to type in my parameter exactly as it appears in the table or risk failure (vs. selecting from a list which would be more ideal).

I am open to suggestions for restructuring anything, and thank you for your time and effort.

Thanks,


Raul


BernhardMechanical.zip

[June7]

Use unbound controls on a form to input parameters.

I don't use dynamic parameter queries but here is example anyway: http://www.datapigtechnologies.com/f...earchform.html

I prefer to use VBA and pass parameters to form or report: http://www.allenbrowne.com/ser-62code.html

[rjv888]

Thank you, I am testing the methods now.