Search results

using MS 2007, but the book I'm working with is 2003.

Okay, so I'm creating a query to create a sum for stock inventory. However on the tabs menu for 'Field, Table, Sort, Show, Criteria, or' the TOTAL tab is actually missing, how do I get it to appear or which tab do I create the Total in?

Okay in my Inventory DB we have headings such as SKU, Standard Product ID, MFR-part-number, Count (which is product quantity and this is the sections where numbers will be deducted) and finally Item Price. In the Orders DB we have Order ID, Order Item ID, SKU, Price. So I'm looking to create...

Okay my boss currently has a database called new orders and that works fine. I am working on another Database called Inventory and basically I need to create 2 queries from Inventory that looks for new orders in 'New Orders' DB and deducts the stock numbers from 'Inventory' Database. Would...

erm not really tbh don't have a clue and haven't touched Access in 10 years.

A standard query help Can somebody please help me on how to write a query to export a table into a delisted text file. Please note I already know to to export data from a table into a text file from the Export menu, however my employer has told me he wants a query or macro to do this.

The problem is I don't actually know anything about Access, I've just been thrown into the deep end.

I think it may have something to do with an append function?

okay I have a table in Access called Inventory with the follow titles Sku, Standard Product ID, Mfr Part Num, count, item price, currency. We regularly get reports in a delimited txt file. I wish to create a query that looks at the txt file and takes the data found under the titles Sku...

okay tables are SKU, Title, standard-product-id, product-id-type, product_type. So basically I keep getting text files, now I want to run a query that takes data from those titles in the text file and updates my main inventory file. My table is called inventory table and my text files will be...

Okay, so I'm wanting to create a query that takes new products from a text file and adds them into an existing table to update. So far I have linked a text file into my database and I have created the table. Looking for the SQL code. could somebody help me please?

okay so I have a main inventory and I wish to create another so when i update data from inventory it automaticlly is placed in new table. Both tables will contain same names so in my new table it will be SKU, Count, Standard Product ID. When i update inventory i want that data in new table under...

Title, SKU, standard-product-id, product-id-type, product_type with a product title of Atelier Interactive Carbon Black Series 1 250ml Jar to Ziggy Art 6 Well Plastic Palette being the last

product names?

no no, the SKU code works fine and populates the table with the correct data, I want to setup the same kind of code but in product title to prompt a user to enter product title and display details if that makes sense.

it works with SKU but a name it doesnt like not sure because it wants it specific, don't know how to set key words instead been long time since used Access

SELECT [Inventory table].Title, [Inventory table].SKU, [Inventory table].[standard-product-id], [Inventory table].[product-id-type], [Inventory table].product_type, [Inventory table].brand, [Inventory table].manufacturer, [Inventory table].description, [Inventory table].Count, [Inventory...

that didn't help but played around with it and got product id to work, but wanna get it to prompt user to enter a name and displays. what would the parameters to be to search for products closer to name?

Would appreciate some help on this, I have created a table with products listing and would like to run a query prompting user to type in name which would display that info into a table. I've set up a parameter table however theres results being displayed

I'm looking to create a database in order to scan a barcode on a packing slip to be automatically entered into database and update an inventory file. I really don't where to begin tbh and would appreciate some help.