Search results for query: *

The 2 fields are called [COMBINE] and [CH 236]. COMBINE is the date stamp of when the data was pulled and CH 236 is the data points we are reading. When looking in the data sheet, the data looks good, but for some reason the graph is horrible. See below for the SQL. SELECT Table1.Combine...

I went into the row source and got rid of the sum total - even with the sum total there, the data was still showing up correctly in the data table. Once I get out of the query and data table, the chart is completely messed up and it does not extract the data correctly.

Hello, I looked up previous posts stating as to how to stop data tables from summing up similar items once the chart wizard was completed. I have done so and it shows each record by itself in table form, but when I go to print preview for the chart, the data is still summed up by days - my...

Hey all, I am busy setting up an autoform in Word 97 for an easy to use template I want to create at work. I never really used Word for something as functional, but I want to this time. I created a form which has a drop down list at the top. When a user chooses either of the choices in the...

Thanks for the info - it will definitely help me out in the future...better late than never! JSF Jason Facey jfacey@lithonia.com

This might be an easy question for most, but I was needing to calulate sigma for a graph in Access and I was needing to find the natural log for defects. How would I write the natural log in the query to solve for sigma? Thanks! JSF Jason Facey jfacey@lithonia.com

Does anyone know what a *.LWP file is? Is this maybe a Lotus WordPro file? It has been years since I have seen this file extension so I wasn't sure. If it is a WordPro file, is there anyway to convert it to Microsoft Word? I am trying to help out a friend who has data she wants to hold on to...

Hello everyone, I am trying to do some ranking of tasks and setting priorities for when incoming shipments need to be paid. I want my columns to automatically change sorting preferences when I change the priority - let's same Shipment1 can be ranked lower than Shipement8. I want to put a...

Good morning all, Seems like a pretty basic question, but I am having problems - I want to use an input form as an edit form also and I can't get it to work. I want to be able to use a field to call out existing records within a saved table. If the field value doesn't exist in the current...

SOrry to write again Kyle, but some problems still came up for me - this is what is in the module: Option Compare Database Option Explicit ___________________________________________________________ Private Sub Report_Close() End Sub...

A history table because I want to be able to pull the part numbers from the part number table then save whatever ticket information in a production history table. Sometimes the user will have to add new parts to the part table and it wouldn't make sense to also have the production data included...

Hey again Kyle, I put the code in just as you have it written, but this error message comes up along with the expression you gave me to fix: Compile Error: Label Not Defined The part of the module that is highlighted to fix is: Resume Exit_Report_Close Is this because the report runs off of...

Ok, ok, disregard the last post. I was putting the history table into the append query, when all I really needed to include was the Ticket Query that report runs off of. Now I am going to try and finish the rest of it...sorry about me being a moron, Kyle. JSF Jason Facey jfacey@lithonia.com

Hey Kyle, I think I understand where you are coming from, but I am having problems writing the append query. I set it up so that when I run the Ticket Query which the report uses, the information will be appended to the history table. My problem is, for some reason, when I run the append, I...

Hello, I am having a problem with saving records in a production history table. As of now, I have created a database which uses a report (PrintTickets) to print out certain production tickets once a product is made. I am wanting to track the tickets that are printed out each day, but I am...

Hey Jack, That would work perfectly and I can see where that would be helpful, but I am needing to take the remainder number to be printed on the last ticket...so we can print the move ticket and have the correct number of parts on it. I need the order quantity on each ticket. Thanks! JSF...

Hello, I am having a problem creating a module that will help my ticket database print tickets. On the current table, I have a list of every single part I need to print tickets for. For each part, I have a column for the stack quanty (stackqty) that is allowed on each pallet. I want the...

Hello, I have a slight problem. First of all I have a data table which has all of my part numbers and their relative information (part description, quantity, unit of measure, how many per pallet, etc.). What I want to do is create a form in which a user can choose the part number, then the...

Hello all, I have a small problem in saving some data into a new table. What I have now is a table that has all part numbers located. I want to use a form I have created to pull up these records so that I can print them out to a ticket with all of the info. I can do this. My problem is that...

Hello, Well the problem I was having was defining fields and then exporting them into Access. If you help me with this, I would be good to go. I know how to use the alpha and numeric functions to set up the model also. Hope this is enough info. Thanks, JSF Jason Facey jfacey@lithonia.com