Search results for query: *

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?

Okay...here is what I tried.... I made the LimittoList = YES Then changed the combo to a value instead of a record. I typed in some customers under record source. And added this. Dim ctl As Control ' Return Control object that points to combo box. Set ctl = Me!CmbCustomer '...

I want to use a combo box to Auto Fill....but I would also like to have the option that if the "customer" is not in the combo box, when I type in a new one it will show up in the combo box next time....is this possible? I tried it on a dummy form and it would replace what was in the combo...I...

How did you guys get the combo box to accept new data?? Thanks,

Need some help around this OCX controller....I have insterted a calendar to use for dates....some users can see this calendar while others cannot make out the days or month on the calendar....the object comes up but cannot be seen. What am I missing?? I am working in Access 97 due to default...

Okay....looking at a pie chart or similar. IMP = Impression Count Capacity = 15000 is total capacity each day If I have 3 orders each with their own impression count for 1 day...need them grouped and totaled so that I can compare to Capacity. does that make more sense?