Search results for query: *

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

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

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

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

Help me please! I am trying to use a program called Monarch to extract data to put into an Access database and I have no idea where to start. Could anyone direct me to a help site? Thanks for your time. Jason JSF Jason Facey jfacey@lithonia.com

Hey everyone, I was hoping I could finish a report by the end of the day and I was needing some help. I have a report which is based on a query and I was needing to calculate the different defects I have under the DEFECT field which result from the parameters chosen when I start the report...

I think this is a very simple question maybe: On one report, I want to be able to give the total number of records that are in the report at the end of all of the records for a specific product I am looking at. On another report, I ask for certain information for any product, not just a...

Hey there, Well i got my queries done, but when I try to creat a report it doesn't work correctly using the wizard. I want to have the report look a lot like my query with what the output is over several months or even years. I enter in the date for when the report should start and then...

Hey everyone, What I was needing help on is seeing if I can start on doing a new report. For the query I am using, I need to have it choose a production month and a production year for when a certain product was created. I am hoping I am able to choose a beginning month and end month, then a...

Hey, I was wondering if it was possible to save my records after I perform my sort so every time I open the table, they are in the order I want them to be in? Access help says no, can anyone shine some light on this for me? JSF Jason Facey jfacey@lithonia.com

Hey everyone, I was needing to know how on a table, I could get the numbers to appear with a zero like 01 for January, 02 for February, 03 for March and so on. I tried changing the format to Number and 2 decimal places, but that didn't work. I was also needing to see if I could change the...

Hey everyone, Very simple question I think---on my input form, I tab around to the different fields, but they do not move around in the correct order. How do I fix this so it is in order? I have no clue where to look for form order on Access 2.0----thanks, JSF Jason Facey jfacey@lithonia.com

Hey everyone, I was just wondering if I would be able to have more than one query or form run when I open my database? In the beginning, I just want to have a form run when I opened a database, but now I will be needing to also run a few update queries when I start to refresh the data on the...

Hey guys, In a table, I have certain fields that in the past the user would insert a "Y" if a product met certain criteria. What I want to do instead, is have the user put in an ID # for one field, instead of having 10 different fields for the 10 different codes---how can I filter...