Search results

Hi We have a database with multiple tables. Each needs to hold a piece of information. The database keeps track of user info, computer info, network data jack and network switch. All the tables are link by using a similar value that exist on all tables, and bringing together by using a query...

Yes, for got to include this piece of information. It is access, in a memo format.

Can anyone help on querying specific information, inside of a cell? Really, I do appreciate your input on this subject. Perhaps, I was not very clear at the begining. The information share above, Product Length: 29.00 mm [1.14 in] Carton Quantity: 80 Shipping (Package) Weight: 0.03 kg...

Really, I do appreciate your input on this subject. Perhaps, I was not very clear at the begining. The information share above, Product Length: 29.00 mm [1.14 in] Carton Quantity: 80 Shipping (Package) Weight: 0.03 kg [0.07 lb] Product Width: 26.00 mm [1.02 in] Battery Type: Alkaline...

Thank you for all your help! However, after typing the information on my query, it works up to a certain point. Below, I have included an example of the query result. [0.75 in] Product Length: 29.00 mm [1.14 in] Carton Quantity: 80 Shipping (Package) Weight: 0.03 kg [0.07 lb] Product...

Thanks for your suggestion. However, I was looking for a query update, select, or append that will do this for me. There are 2000 plus records. It would be a collosal job doing one by one.

Hello, I have a query with a paragraph that needs to be split in two. In other words, normally in word program, I would hit the "Enter" Key. But, in access query, one is no so sure how this process is done. COuld you provide an example on how to split the two paragrah. For example, if the...

Going back to first question, I need to extract the weight of each product. There is a line on the product description that shows the weight in lb. I need to pull this information for shipping and handling calculations. Can you help me on how to extract this information, alone. Thanks

I was hoping to separate each of the technical descriptions. Each product has several technical descriptions. Separating the information it will allow me to export the information to my import/export tool. Another important information, before getting the information to access, the product...

I created a query. then, right next the column name, I place the code. Technical: Mid(Trim([Product Height]),InStr(1,[Product Height],"[")) This did not work. Then, I tried using it under criteria. it did not work either.

Perhaps, I'm not to an expert, but when I tried to use your code, it gave me a box to enter information. Where should I be using your code. Thanks

There are about 2,200 products. Each product has a column called [Technical]. Each record has about the same technical specifications specified on my first submission.

I'm looking to develop an access query to separate this information, Product Height: 19.00 mm [0.75 in] Product Length: 29.00 mm [1.14 in] Carton Quantity: 80 Shipping (Package) Weight: 0.03 kg [0.07 lb] Product Width: 26.00 mm [1.02 in] Battery Type: Alkaline Voltage: DC 4.5V in...