S
Steve
OK I give up and I'm embarrassed to have to post this but I need help and quick.
I'm not a regular user of Access (far from it) last version I used was 97 and
that was probably 2 years ago. I've just spent 2 days trying to do what I'm sure
is a very simple and I'me getting nowhere, so can somebody please help.
This time I'm using Access 2003 (not sure if that's an issue) but here's what
I'm trying to do:
I have 2 Excel spreadsheets each having 10 Fields.
Spreadsheet 1 (1,111 Records)
Spreadsheet 2 (364 Records)
Field 3 is the common link the field in each spreadsheet is in the same format
"Text" and have the same field name. This field is common for various numbers of
records (between 1 and 20) in spreadsheet 1
I've linked these tables as "Imported Data" into Access with no problems.
All I now want to do is to produce a report listing all the records less (field
3) in Table 1 (1,111 Records) broken down into groups (field 3) together with
the associated fields 4 and 5 of Table 2.
I've read and modified the above and am still not sure if anyone can understand
what I'm trying to do so as they say "A Picture Say's A Thousand Words" Just
hope the formatting of this remains readable on usenet.
[TABLE 1 F3] [TABLE 2 F4] [TABLE 2 F5]
INDENT [TABLE 1 F1] [TABLE 1 F2] [TABLE 1 F4].Through To..[TABLE 1 F10]
...Continued for each group of records where F3 of Table 1 are common.
Then repeat for next group of [Table 1 F3]
Would someone kind soul please be kind enough to talk me through it. I'm going
crazy, for example why does my report suddenly end up wth 5000+ records?
Steve
I'm not a regular user of Access (far from it) last version I used was 97 and
that was probably 2 years ago. I've just spent 2 days trying to do what I'm sure
is a very simple and I'me getting nowhere, so can somebody please help.
This time I'm using Access 2003 (not sure if that's an issue) but here's what
I'm trying to do:
I have 2 Excel spreadsheets each having 10 Fields.
Spreadsheet 1 (1,111 Records)
Spreadsheet 2 (364 Records)
Field 3 is the common link the field in each spreadsheet is in the same format
"Text" and have the same field name. This field is common for various numbers of
records (between 1 and 20) in spreadsheet 1
I've linked these tables as "Imported Data" into Access with no problems.
All I now want to do is to produce a report listing all the records less (field
3) in Table 1 (1,111 Records) broken down into groups (field 3) together with
the associated fields 4 and 5 of Table 2.
I've read and modified the above and am still not sure if anyone can understand
what I'm trying to do so as they say "A Picture Say's A Thousand Words" Just
hope the formatting of this remains readable on usenet.
[TABLE 1 F3] [TABLE 2 F4] [TABLE 2 F5]
INDENT [TABLE 1 F1] [TABLE 1 F2] [TABLE 1 F4].Through To..[TABLE 1 F10]
...Continued for each group of records where F3 of Table 1 are common.
Then repeat for next group of [Table 1 F3]
Would someone kind soul please be kind enough to talk me through it. I'm going
crazy, for example why does my report suddenly end up wth 5000+ records?
Steve