Search results

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

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

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

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

Hi, Due to the way my system reports sales data, I have 2 tables that I'm not sure can be directly connected in a query. Table 1,tblSales, includes fields such as Customer Number, Part Number, Sales Value, etc. Table 2, tblContract, includes contract information for all of my customers such as...

Hi, I would like to add a combo box on my form to add records to my table. Currently I have this box looking up to the field "Customer" on my table. I'm doing this to help the end-user add a new record with a correct and consistent customer name. The problem is that it is showing duplicates. How...

Hi, I have about 30+ report formats saved in my database. Generally I open the table in which the data is stored, filter, open the report, and I update in properties to show my filtered data. I'd like to eliminate these steps by using something like a form to choose my filter criteria and have a...

Hi, I have a form in which I would like to use a list box to add records to a table. At first, when I had the list box reading from the table field: Customer, it showed many duplicates. My solution was to run the list box off a query that showed unique vales. I am not sure if that was the...