Recent content by vincesavoldi

Unfortunately that link didn't work and I couldn't find the article by browsing it. ;)

I have a report that shows 3 pivot tables on the same page. What we would like to do is total (or perhaps subtotal) the three tables into a summary table. each table has number code, name, data 1, data 2. The three tables are identical with the exception of I filter on only specific number...

:rolleyes: I think I can see how that will work, it changes everything in terms of how I do things but hopefully I continue to learn the proper way to use the tools. thanks!

I will look into that, thanks! I understand that a single table is best, just getting it worked out seems to be stumping me. :cool:

hmmm now I am really confused, let me try to break it down.. One table... I like that idea.. If this table has all 25 of my gadget BOM's are they records? (rows) or fields (columns)? If they are records then how can I list all 250 items + Qty's required using the fields - And actually this...

I think I understand relational databases and normalization but I will go read your reference link just to see and better understand what it says. Yep, in order for my BOM to have each item (some are as many as 250 items) and Qty Needed, I believe have to have each BOM as it's own table...

Hi All, I am having an interesting time on a project. I am trying to create a small inventory management database with BOM (bill of materials) control. Today I am working on how to create the BOM's. In case your not familiar with inventory management, a BOM is basically a list of items and...

Well, thanks for your input, and I can see how the code line works, but I have no idea how to implement that. I get an error trying to use it as an SQL statement query so i am afraid it is above my knowledge level. I do appreciate your time and effort trying to help! :D

I have no idea how to do that. I am very familiar linking access data into excel, and manually exporting a table is easy but how would one export a crosstab if it is not making a table when you run the query? The person doing my reporting before myself used to spend many hours in Access to...

Basically I would need the table to generate a report either in access or taking it out to excel for a pivot table or simply for a lookup table. I totally do not understand how someone would use a crosstab query without taking it to a table. While the crosstab seems to generate what I am...

I'm not sure how to specify this, I have tried everything that looks like it should work. I seem to have made something work properly but as soon as I click on make table to create a table it breaks the crosstab. I am sure I am doing something wrong :(

Yes actually I played with it quite a bit and came close but could not seem to filter the dataID correctly. The query would find the 1st instance of Item-type-price and ignore the remaining. Using 2 queries the crosstab worked beautifully as the 1st query would select only the items with the...

Hi all, I am having an issue sorting out some data.. I can do it using multiple queries but I would love to find a way to do it in a single query... Sorry If I am not using proper terms but Being very new at this i have not learned everything yet :o I have formulated a couple sample tables to...

Hello Everyone, brand new here, just got registered. I have been lucky enough to find most my questions answered here somewhere but I am having an issue that I need to post a question (See new message in Queries) Seems like a great forum and I look forward to being able to help contribute...