Search results

I have a table with style number field, a style description field, a INSTOCK ("Yes/No") field, and a qty field. Some of the style numbers are unique, others appears many times in the table. I want to be able to get a list of all the styles in the same manner I would do using SELECT DISTINCT...

Oh God I found my error, it's so stupid I won't say a word. Forget about it, tx anyway.

Actually it's vba code in an excel sheet, pulling data from an Access table. I have no reference to a query, I'm running a rst.open sql style connection. There's no report in the access db, although I have a few queries. How can it work now that I have change the field name in the table?? I...

Hi all, I use to have a field named RDI_ID, later on I decided to change the name to RDI to make things easier. I have several macros pulling recordsets, but they stopped working, even though I have changed that field name to RDI in the macro as well. Curiously, they do work when I change it...

Hi all, I use to have a field named RDI_ID, later on I decided to change the name to RDI to make things easier. I have several macros pulling recordsets, but they stopped working, even though I have changed that field name to RDI in the macro as well. Curiously, they do work when I change it...

You are right. I just noticed that I forgot an important detail. I have to get a recordset of items that match a specific location. So I use the location table (which I call tblItems), as being the source. Then I lookup the description in the actual item table (that I call tlbDesc). I'm sorry I...

This is surely simple, but I can't figure it out. Basically here are the 3 tables in my query with their respective fields. tblItems (ItemNo,Location) tlbDescriptions (ItemNo, ItemDesc) tblOrders (ItemNo, OrderQty) I want to list all items with their related descriptions and list any orders...