Access File from an other without related fields?? 
Author Message
 Access File from an other without related fields??
Is there a way to read the records of a file from an other without using
related fields??


Fri, 27 Sep 2002 03:00:00 GMT
 Access File from an other without related fields??

Read which records in the other file (if they're not related, how are you
selecting them?), and do what with them?



Quote:
> Is there a way to read the records of a file from an other without using
> related fields??



Sat, 28 Sep 2002 03:00:00 GMT
 Access File from an other without related fields??
I want to scan sequentily an other file to extrat some information. I tryed
with the relations but I can just access the first record that match the
relation (feild1 = field2). I want to how can I access an other file, read the
records to find those who are matching (file1filed1 <= file2field2 AND
file1field1 >= file2field3). Than I want to extract the information I need
(Code and goup number)

Glenn Schwandt :

Quote:
> Read which records in the other file (if they're not related, how are you
> selecting them?), and do what with them?



> > Is there a way to read the records of a file from an other without using
> > related fields??



Sat, 28 Sep 2002 03:00:00 GMT
 Access File from an other without related fields??
Ok, you answered the first part (which records), but are kind of vague on
the second part (what you are doing with them).  Do you need to put some
part off all matching records (code and group number) into one field in the
other database, use it in a value list, run a loop and perform some
function on each matching record...

Give as much information as possible.



Quote:
> I want to scan sequentily an other file to extrat some information. I
tryed
> with the relations but I can just access the first record that match the
> relation (feild1 = field2). I want to how can I access an other file,
read the
> records to find those who are matching (file1filed1 <= file2field2 AND
> file1field1 >= file2field3). Than I want to extract the information I
need
> (Code and goup number)

> Glenn Schwandt :

> > Read which records in the other file (if they're not related, how are
you
> > selecting them?), and do what with them?



> > > Is there a way to read the records of a file from an other without
using
> > > related fields??



Sat, 28 Sep 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Related Find without Indexing the Match Field in the Master File

2. Linking Access Tables in Different *.mdb Files, Populating an Access Table From Several Others

3. How to relate a field to another field in the same Access 97 table

4. How to relate a field to another field in the same Access 97 table

5. using Access file without Access

6. How to relate two files on multiple fields

7. Calculation Field from Related File with list

8. a complicated question related to related files

9. Value List based on a field in a related file

10. 1 big notes field vs. related notes file

11. Relate Fields in difference files


 
Powered by phpBB® Forum Software