Creating tables

[Armata]

Hi

Need some help with querries.

I've got table that has schedules for products (fields: idProduct (FK), idDay, Required).
Records are ordered like this:
1 1 92
2 1 92
3 1 104
1 2 108
2 2 96
3 2 102
...
I need to "export" to tables data for all idProduct (Table1 - records for product 1, etc.)

Can anyone tell me how to do this?

Armatka

 

[dpw204]

Hi Need some help with queries.
I've got table that has schedules for products (fields: idProduct (FK), idDay, Required). Records are ordered like this:
1 1 92
2 1 92
3 1 104
1 2 108
2 2 96
3 2 102
...
I need to "export" to tables data for all idProduct (Table1 - records for product 1, etc.)

WAG - I'm not clear from your input what your expected output is. A cross-tab query may be what you're looking for which would generate an spreadsheet like output. e.g:

IDDay Total of Value: 1 2 3
1 104 92 92 104
2 108 108 96 102
========================
If that's close to the output you're looking for, checkout the Cross-tab query tools available with Access. -
========================

 

[Armata]

I want to get otuput like this:

Table 1 (idProduct (FK), idDay, Required)
1 1 92
1 2 108
...

Table 2 (idProduct (FK), idDay, Required)
2 1 92
2 2 96
...

Table 3 (idProduct (FK), idDay, Required)
3 1 104
3 2 102
...

 

[boblarson]

Why would you need other tables for this? Do you understand that you can use QUERIES just like tables in 99.9% of time? So whatever you intend to use those tables for, can just be queries from ONE table.

 

[Armata]

Ok...

So how can I calculate value in record using value from previous record?