Loop Query

[LordLoki]

Hi there,

i hope someone here can give me a clue in the right direction cause i dont know if what i want to do is possible or not.

I have to tables that contain Data that i need to create a new view.

First Table is like this
Year
Weeknumber
Queue
Value

Second Table is like this
Weekday
Queue
Share

now i want to create a view that breaks down the weeknumber into 7 days and multiplies value from table1 with share from table2

So that i have a table with
Date
Queue
Volume

I know i could do it with VBA but i would like to know if you could do it with a normal query.

I hope i could make clear what i want if not feel free to ask
Thanks in Advance for your Time

Greets
Marc

 

[plog]

Can you post some sample data to illustrate what you currently have and what should result? Be sure to include table and field names.

 

[LordLoki]

Yes i will post sth when im home