Search results

Hi. I am having difficulty with mathematical expression builder. In "Form 1" i have text boxes 47 and 61 which store values in a table. In "Form 2" I have to perform a calculation using these two text box values. I want it when you open form2, once you have put in the values in teh previous...

So if i have ten fields labed Value 1, Value 2..... Value 10, using the cross tab query how would i get it so that the query returns it in one column. once i get a query to return it as one column i want to find the standard deviation of the values in another form.

In one record (or row?) there I have 10 fields (columns), how can i find the standard deviation of those 10 numbers. Seems to only want to be able to do standard deviation if all data is in one field or column. I tried doing a query but same thing, if all the fields are across, it doesatn find...

Simple query the table and put in ShortCodeField: Left([CodeFieldName],7) where do i put that in???

I was wondering if its possible to.... In my business, we test electronic components. When one fails, it gets documented as a test error, and the document is named TE-XXXX YYY where XXXX is a four digit number and YYY is a code of some sort. is it possible that in a table, When TE-XXXX...

okay, even zipped up its 900 kb, too big to attach? any other suggestions, email etc?

Okay, i'll post the database.....the form of interest is "New Units".....that adds data to the table "General" then all the update queries add whatever fields are the same to every other table. Thanks in advance.

This is a very simple problem most likely for the masses, but I am new to access. I have employees who enter will enter information about specific tests on electronics components into separate tables by a form. I know my method is poor, but this is how it works. I got assigned this database...

Lol, where the heck is that????

On a form, I have a text box linked to a field in a table. So as you use the arrows on teh bottom left of teh page, you scroll through the fields in the table. In my table, I have the records sorted numerically in ascending order....... why is the textbox, which is linked to this table, as you...

Hi, when I run a simple append query, I get the following message below (See attached) I tried the solution in microsofts website that I have to set all text fields to AllowZeroLength to Yes, and i did that in both the table the data comes from, and the table the data is appended to. Still...

Is there a way to find and remove duplicate entries in tables by using queries.....if so, how specifically?

Im tryin to append one column to multiple tables at one time. I have a separate query that is suppsoed to append to each table, being run from one macro. It adds it to the first table, but on the second table, it says with the usual warning message "Warning, will append 0 tables" AKA, its...

I am trying to add data to the same column which is in multiple tables at once by running a macro that has multiple queries. I run a macro, and the first is a delete macro, which deletes the column and then the next is an append query which then adds the new column wtih the new data....and it...

I am trying to run a query that appends data into a table.. however, the way im setting it up.....lets say i have a table named Accouts, and under accounts there is #1 to 30. When I try to add a new account through a form, and append it to that, it takes the 31 there nwo are after i added...

Could someone please try to give me a step by step method for using an append query to update a table. Gary gave me a ton of help before but im still a little stuck. Thanks in advance. :)

and i feel like im gettin it, but im a little confused.....when im designing my append query...... if i type the data and it originally goes into table "General" under column "SN_PN". and i want it to also go into table "IOCA" under "SN_PN" as well...... what exactly do i want to have in...

okay im tryin this append query thing.....so u can only append to one table at a time.....so i may have to create a macro that runs the same query multiple times or a different query each time and each time it adds it to a different table?

sorry this took so long, had to remove a bunch of information per company standards, and then my computer froze....took 5 minutes to relog on... im gonna try posting it in my original post. thanks for you help, i appreciate it so much

97 lol. gotta love my company