Search results

This does work thank you. However, if I am in design view, and then switch to form view on this particular form, the form just goes blank. Although it works when I navigate from the switchboard to this form, then click close. When I choose the form from the switchboard, the form opens up with...

Hi, I've seen a lot of posts out there on this, but I can't find any replies geared to what I am looking for. I am using a very simple form bound to a 1 record, 2 field table that has a textbox and 2 command buttons. This form's properties are set not to allow additions, not to allow deletions...

Here is a copy of the SQL along with a snapshot of the query. I checked the relationships, and I suppose I did not have anything built. I have to admit also, for simpler purposes, I have not normalized this very far either at this point. Is this sufficient for now? If not, let me know, and I can...

Hi, I cannot find a thread relating exactly to my topic as I need it, and I need help with min max functions. I am using a select query to pull from a couple of warehouse inventory style tables to give me part number, description, cost, and qty. The cost and qty fields are listed by location and...

Hi, I'm operating off of a query that is a composite of inventory and cost information of material sold by my company that we want to select from to build a quote or sales order. This information includes data such as part number, material classes, descriptions, and then stock/on hand quantities...

I'm sure this has been asked a hundred times, but i cannot find a good answer. In a table, I am trying to copy paste from one field, one record (cell), into multiple records of that same field or any field I wish. Basically, I would love to highlight any range, whether it is single or multiple...

Hi, I have 2 tables in which I want to be one table. I'm trying to copy and paste the data from table A into table B, but nothing is happening. How can I transfer records from one tbl to another? Thanks

Hi, I'm using a query to apply branch cost to a customer contract by part number. A record consist of a part number, description, and branch cost fields ranging from 3 or more. For that record or part number, I would like to display the highest branch cost perhaps as the last field in that...

Great!! Everything I needed to know has been answered

Excellent! By chance would you know how to create a blank column. I forgot to mention that I need a space between the Quantity columns. Thanks.

Here you go. Thanks. ------------- SELECT [Conversion Table].Description, [Append Table].[Report Date], [Append Table].Well, [Append Table].Quantity, [Append Table].Quantity FROM [Append Table] INNER JOIN [Conversion Table] ON [Append Table].[Part Number] = [Conversion Table].[Part...

It returns with no results. I see the field names but no records.

Ok, I've uploaded both the usage table and the end result query. Again, by nature, the positives and negatives are in the same quantity field on the usage table. I'd like to split the +/- values into their own fields. Thanks.

Ok I'm not get anything when I run the query. Let me explain what I have done, and see if I did anything wrong. Forget about the previous attachment and relationship I was talking about. We are going to go with just the main usage table from which this data derives from, and a sample of it is...

Hey folks, Need help with the following. I have a table that list usage fields such as as Date, part #, Order #, Desc, Qty, etc. I append usage reports to this every so many days. Moreover, I have a 2nd table that I use to convert multiple part #'s into one generic description. This is necessary...

Hi, I'm in the conceptual phase of this database, and I'm working with the attached Excel sheet for my customer. I'm trying to take what they manually enter into a spreadsheet, and automate through a database design. In short, it is a sales usage report that shows the quantity of accumulated...

Here is the SQL. Please let me know if this what you meant. Thanks. SELECT LineitemGM.[ORDER NO], OrderGM.[Order Type], LineitemGM.Date, OrderZSA.CUST, OrderGM.[Ship To], OrderZSA.[CHRG BR], BRANCH.LOC, OrderGM.ISR, LineitemGM.[LINE NO], LineitemGM.[PART NO], LineitemGM.MT, LineItemZSA.IC...

Hi, I please need help with the following. I have 2 fields from 2 different tables, Charge Branch and Source Branch, in which contain the branch number associated with charge or source. Then I have a table in which I store the branch name (Branch), and I join the number to the name. To make the...

Hi, I have a crosstab query that I only want to return a value < 1 .75 from the table it is looking from. In other words, if it exceeds 1.75 then I need to say NA, and if it is less than 1.75, I need to display what it found. How can I do this? Thanks

Ok, I made a mistake in my speaking here. Yes, the order number can be on more than one record as multiple items on that order are entered into the form. So the order number field and part number fields would come together to be unique. Is this easy to implement?:confused: