Search results for query: *

I want to make list of all the Mfg from my parts table, but the problem is how do I get one listing for each item? For ex part table mfg partnumber etc apple 123456 apple 134567 apple 145624 bike 123465 car 123468 select * [parts] order by [mfg]asc apple apple apple bike car...

I am working on a web page in search box , I came along a website that has a search feature lookup parts or has a dropdown box with MFG names in it.You select Apples and it brings up all apple products.I like that feature. I have search working , but cant get the drop down box to work. See...

I have designed a webpage for part info , a search and results Linked to a Part database , but I want to search Data base for part numbers, I can search for exact using Select * from Parts Where Part_number like part_number But I want to use wild cards *123* results 123456 Screw etc Any...

I am using Access 2000 , Calendar control 9 ,I would like to link a database to the calendar. For example ,everytime we rent a condo out it would block(color) out the dates, startdates,enddates for each record.I am open to suggestions

I am usinng Access 2000 ver 9, my data base has line#, parts # , descriptions , price ,.etc I was wanting to create a report out this info I can do a single report(order Form), how do you multi-items ? Example: line qty description price Total 0106 2 Salt .99 1.98 0111 1...

Long story short , I use access 2000 ver9 sr-1 I enter all orders in our data base and now i want to start billing from there as well.However I ran into a small problem.. see example Qty1 Descript1 shipped unit price1 total Qty2 Descript2 shipped unit price2 total Qty3 Descript3...

Hello All, This is what I have , I have a 4000 item database on products for different Customers.Where and how to buy them etc.(vendor name address Etc). In excel we created a fax form for each one of these items.(over time either excel or access data begins to differ on price or updates). I...

I have a good Question , I have two tables (1)inventory (2)Orders I have relationships with part# , So when I run A Query Inventory & Order I only see what is used . See Example Date Part# Rel orderAmount Inventory Stock 8/22/03 1234 1 10 12 2 8/25/03 1234 2...

I have a the following fields in my table : Supplier---Address--phone---fax-- I made a form using these fields ,(there are more fields customer etc.)It like a order form . I would like to use a combo box for supplier,and pick the vendor (which I did )--But i would like to take it a step...

I have a Table with the following columns : Item Qty Price StockTotal wig 2 $1.00 $2.00 ABC 3 $3.00 $9.00 How do config the stock total to work ? Also how can I get a total Inventory in this Example $11.00 Any Ideals Thank you for your help