Recent content by stlrain95

Here is what I have.... SELECT MASTER.Order_Date, MASTER.Cell_Loc, Format(Sum([IMP])/(Cell.PPM),"#.##") AS [Print Hours] FROM MASTER, CELL GROUP BY MASTER.Order_Date, MASTER.Cell_Loc, CELL.PPM; Notice the group by with Cell.PPM....I don't want this part of the group..but can't take it out...

Okay...it is asking me for the "order Date" which is fine. How do I do 2 more things. Print Hours is giving me 111.1111111 I only need 2 decimal points. And is there a way to differentiate equipment based on times?? For instance, 1 piece of equip can handle 4500/per hour While another 3500...

Not sure about the structure Question... Equipment/Cell Impressions Order Date BOOKS- 4 DOC - 6180 1000 1/05/05 CNC- 1 DOC - 135 1000 1/05/05 I can print 4500 impressions/per hour on the DOC 6180 So in print hours...

I am needing a query for "Print Hours". How do I get this? This is what I need: I have 8 pieces of equipment I have a date and I need to calculate Print Hours using this formula SELECT Sum(MASTER.[IMP])/4500 AS [Print Hours], MASTER.Equip FROM MASTER GROUP BY MASTER.Equip; I need this query...

Awsome....working greatness You get a star!!

Alright, in the form I have a list box displaying 2 columns of information. What I need is when I make a selection, I need both to show in the field. Example: Cell.Cell & Cell.Equipment show in drop down But only Cell.Cell displays when selected.

I have a list box that displays 2 columns from a SQL row source. Sample: SELECT CELL.Cell, CELL.Equipment FROM CELL GROUP BY CELL.Cell, CELL.Equipment; When I select from the list box....I need both fields to display in the results box. How would I go about doing this?? Thank you,

Greatness!! Works. thank you,

Sorry, but I need the day in there because I am summing IMP by Day....I have dates in there. So what I need is this. 11/11/04 2000 11/11/04 4500 Total Available 15000 11/11/04 Sum: 6500 11/11/04 8500 11/11/04 Available. Hope that helps more.

Thank you ma'am...got it.

SQL is the same as example above. My data is normal. I am consistent with 15000 And the IMP is across the board. IMP = 2000 & 4500 (same date) So the sum for 1 day should be 6500....but it is coming out 48?? Remaining count is fine....but based on the 48

I have a combo box in a form that I need the ability to add new data if necessary. I created the combo tied to a table. here is the code behind the combo box. Dim demo As ComboBox, strMsg As String Set demo = Me!CmbCustomer strMsg = "This Customer is not in the list. Would you like to add it?"...

It is really weird.... I have 6500 as a sum for the impression count...but when I run the query...it comes up with 48?? What could be causing this issue??

It does...thanks,

PH...you have lost me...I have no idea what you are talking about?? Can you please explain?