Search results for query: *

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

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,

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

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

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

I am trying to create a chart based on the 2 pieces of data. I have a standard capacity of 15000 and fluxuating counts. I want this sorted by day. Here is my query...but doesn't work right?? SELECT Sum((Day([IMP]))) AS [Impression Count], 15000 AS Capcity, MASTER.Cust_Date FROM MASTER GROUP...

I have a 4 Tab Control with everything going into 1 Master Table. Outside the Tab control I have basic information. When opening the form, if a txt box reads "NO" then I want to NOT enable the first tab...the remainder would be. Also, when certain fields are filled in the tabs...you can...

I changed my boot up in msconfig to boot safe mode, normal. The problem is now I cannot log into XP Pro with admin rights or others...and cannot see the domain. When I change the boot.ini file in DOS, it disappears when I reboot. What can I do without reinstalling XP Pro??

I have 2 joined tables but I am trying to get a query where items sold greater than 6 months ago but less than 1 year within this query. I seem to be having trouble obtaining this. SELECT SOLAR_CustItem.[Part Number], SOLAR_CustItem.[Description 1], SOLAR_INVENTORY.[Item Code]...

I am trying to format a column in Excel with a date/time, but the format will not work due to a "'" before each date. How can I eliminate this character without doing a right justify? example: '3/31/2004 2:40:53 PM Thanks,

I have a SQL Query where i am pulling from 4 different tables. 3 of the table contain Order, Part, and Lot #. Lot # is unique in those 3 tables, so an Order # can repeat. But I have the Shipping table that only contains the Order #. In the query I want to eliminate duplicate Order #s with...

I have data that has been imported either Tab or Space deliminated and when I try to do a formula to SUM the #s in one column....it doesn't recognize the numbers. I have tried to reformat. HELP!! Thank you,

I am using the following query to get Count results from Multiple Table...but I need each to make their own column? I am not sure the UNION is the right answer? SELECT Format([RECDATE],"Short Date") AS DayRecd, Count(MASTER2.ID) AS [Rec Qty] FROM MASTER2 WHERE...

I have a spreadsheet that I have pulled from an Access table. The Spreadsheet is hardcoded with a "General Date". Which is mm/dd/yy hh:mm:ss PM. I am trying to format this date to just mm/dd/yy, so that I can do a pivot table on Date. Formatting this field does nothing for the...

I want to do a direct network connection to a second PC...is there a simple piece of HW to do this? Really just wanting to copy/move some files from one computer and put onto the other without burning CDs. Thanks for the help.

I have a Database that I have distributed through a warehouse. They use this DB strictly in Access Runtime. But for some reason, every so often, I get an error that I need to repair the DB. Access 2000 repairs the error, but I have to boot everyone off. Is there a more simple solution...

I am trying to calculate Cycle Time for my warehouse. I am using a start time & End Time to calculate The format is MM/DD/YYYY H:MM I would like to get the actual hours from this. But, a simple calculation doesn't give me anything more than 24 hours. Can this be done??

I am currently using a VB form to insert data into an excel spreadsheet. I would like to take the date/time and find the day of the week. Once I have that day of the week, put the data into the day tab. I am sure this can be done...but perhaps not hair pulling. thank you,

After a text field has lost focus I am automatically updating the table. But I also need the form to close. I have tried DoCmd.Close DoCmd.RunCommand acCloseForm What am I missing? Thank you

I need to update a Master table with a 2nd subform that is filled out later. But obviously it has to search for the existing data first and then insert the updated data. Any suggestions??