Linked text and queries with Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have 2 linked tables from a text file. Since they're linked i cannot set a
key or an index for a field.
I want to make a query which gathers several fields from these 2 linked
tables. I've made a relationship between these 2 tables (which by the way is
Indeterminated).
When executed, the query asks me to enter parameter values for fields of the
second table. If i hit enter and leave them blank then the query executes
with the correct data from the 1st table and blank data from the 2nd (which
is wrong of course)
I've tested converting these linked tables to local tables and used an extra
field as primary key and the queries work fine...

Since I want to use the linked text function is there any way to make the
queries work right?

Sorry for the long post.
Thanks in advance
 
Assume your use access to write your queries:
Can you open your link table from access?
What are your fields name for these two tables?
Assume you use select statement:
What is your Queries?
Is your select field match to your field name from the table?

If all those check, you should see some data when you run the query.

Other option is try to recreate your query by "create query in Design view"
or "Create query by using wizard"
 
Hi, thanks for the reply
Yes i can open the table from access.
The query look like this:

SELECT
Dimos.ID, Dimos.ID_Dimou, Dimos.Onoma_dimou, Dimos.ET_OK,
Dimos.ET_Total, Dimos.Population, Dimos.Registered, Dimos.Voted, Dimos.Egyra,
Dimos.Nomarxia_Dimou, Dimos.Time_stamp,
Ypopsifioi_Dimou.Onoma_Ypopsif, Ypopsifioi_Dimou.Psifoi,
Ypopsifioi_Dimou.Pososto, Ypopsifioi_Dimou.Eklogi,
Ypopsifioi_Dimou.Aperxomenos, Ypopsifioi_Dimou.Onoma_Syndiasmou,
Ypopsifioi_Dimou.Ypostirixi
FROM
Dimos INNER JOIN Ypopsifioi_Dimou ON Dimos.ID_Dimou =
Ypopsifioi_Dimou.ID_Dimou
GROUP BY
Dimos.ID, Dimos.ID_Dimou, Dimos.Onoma_dimou, Dimos.ET_OK,
Dimos.ET_Total, Dimos.Population, Dimos.Registered, Dimos.Voted, Dimos.Egyra,
Dimos.Nomarxia_Dimou, Dimos.Time_stamp, Ypopsifioi_Dimou.Onoma_Ypopsif,
Ypopsifioi_Dimou.Psifoi, Ypopsifioi_Dimou.Pososto, Ypopsifioi_Dimou.Eklogi,
Ypopsifioi_Dimou.Aperxomenos, Ypopsifioi_Dimou.Onoma_Syndiasmou,
Ypopsifioi_Dimou.Ypostirixi
HAVING (((Dimos.ID_Dimou)=350));

Thanks...
 
Back
Top