Search results

I simplified the problem for posting. There's actually labor + parts cost. There's a base labor cost shared by all the sub part numbers, but it can go up or down if the repair is unusually easy or difficult. It's the parts cost that usually varies greatly. Customers call up and ask what our...

On second thought... I can't do a high limit due to the wide variety of repair prices. What's reasonable for one product may be unreasonable for another. I think tossing out the high and low is the best I can do. So, I'm back to square one. Is there a way to uncomplicated the solution?

Galaxiom - the parenthesis are there (I corrected the post), they got left out when I did the cut and paste. Read below. I think I'm going to make an adjustment, although it may still be too "complicated" for Access. plog - your argument doesn't hold up in this case. The base repair price...

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...

The Managers are chosen from a combo box linked to a junction table between the Non-Conformance table and the Managers table. The junction table lists Non-Conformance ID#s and the corresponding (combo box chosen) Manager ID #s - each a separate record. (One Non-Conformance ID may correspond to...

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...

You're right, of course. I've never come across the need for a junction table before but I'll give it a shot. Looks interesting. Thanks

Cronk, here's what I was looking for: Dim Value As String Value = "Account Mgr, " If (IsNull(Me.IssuedTo)) Then Me.IssuedTo = Value Else: Me.IssuedTo = Me.IssuedTo + Value End If I just cut and pasted for each of 8 Click events. If I need to retrieve the individual...

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?

Thank you kindly. I'd tried the Nz function without the ,0) to no avail. I don't know why I torture myself so needlessly when there are so many people like yourself willing to help.

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...

Thanks Paul, that was so simple Tina Turner could have figured it out. I know about grouping and summing, but had lost consciousness of the fact that the sum function would automatically get rid of the duplicate names even though I used it earlier in the process.

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...

I just clicked on your avatar and saw you are a "IT Manager for a transportation company" Guess I need to post some personals.

Hi Paul, not big into the cars - do like a party however. What do you do here in Reno?

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...