Search results

I need to get an average repair price of multiple part numbers with the same root number i.e. 8 each 8TJ124GGN1 4 each 8TJ124GGM1 7 each 8TJ124GGP1 First I used a query to average the repair price of each subset of numbers, and then queried the query to average all the subset prices together...

Hi there, I have a subform to select which Managers will get a Corrective Action Report based on a single Non-Conformance ID. The queried information looks like: ID Managers 01 QA Mgr 01 Maintenance Mgr 01 Shipping Mgr How can I access this data 1 record at a time in order to have each...

I’m constructing a form with checkboxes next to names. I’d like to have the checked names input serially into a single table field like: IssuedTo Name1, Name2, Name3 There are 8 possible Names. Is there way to do this without a long complicated If-Else-Then function?

In the following simplified query, in some months(MonthOf) there were no warranties so I have a null field for AcceptedWarranties: SELECT qryWarranty.MonthOf, qryWarranty.AcceptedWarranties FROM qryWarranty; In order to make my Warranty Trends graph work I need 0s. Other postings show the...

The results of my union query of 2 separate tables looks like: Name - Count of Participations Joe Blow - 7 Harry Smith - 11 Kate Upshaw - 8 Joe Blow - 3 Harry Smith - 5 Kate Upshaw - 13 I need to combine the duplicate names and total their participations to make a report look like: Name...

Hi, I work as the quality manager for a commercial aircraft instrument repair company and have somehow become the go-to-guy for modifications and additions to the Access database - this despite the fact that I'd never done programming before. Most of the time I look at existing code and cut...