Recent content by rob.lyles

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