Product & Specific Month

[sixstrings]

I'm trying to query Product to specific months so I can enter quantities. But no luck.

Example

Tables:
Product (Product Name/ Quantity)
Months

Output Query:
Product Name 1 - September Quantity & October Quantity
Product Name 2 - October Quantity
Product Name 3 - October Quantity & November Quantity

 

[ggreg]

Do you not have Months in the product table you have two tables
and Month is a table by itself ....do I understand that you do not have
a month field in the product table?

 

[sixstrings]

There are two tables.. "Months" table and a "Product" table. (I'm open to any suggestions on the best way to set this up).

What I am trying to do is assign months to the specific product, so then field reps can enter quantities based on the month that is assigned to it.

 

[ggreg]

if you can add a field to Products, I would add a new field called tmonths
put t with months because months maybe a key word then you will be able
to link your months table with Products tables...but in the new field add in
the months you want or need with each product then you should be able to
set up a query to work the way you want it to

 

[sixstrings]

Thanks! I'll set it up that way.

 

[Mile-O]

Do you not store a date in the first table? Storing months is bullshit as is a table for months.

 

[Rich]

How will you know which year you're sales are in if you only record the Month?