unknown query error

[basilyos]

hello it's me again

i have a query

SELECT qry_Ma7adir_karar_7abes_9.IDD, qry_Ma7adir_karar_7abes_9.Register_Date, qry_Ma7adir_karar_7abes_9.P_ID, qry_Ma7adir_karar_7abes_9.Name_Ma7dar, qry_Ma7adir_karar_7abes_9.Full_Name, qry_Ma7adir_karar_7abes_9.Mother, qry_Ma7adir_karar_7abes_9.Birthdate, qry_Ma7adir_karar_7abes_9.Nationality, qry_Ma7adir_karar_7abes_9.Record_Number, qry_Ma7adir_karar_7abes_9.Record_Place, qry_Ma7adir_karar_7abes_9.Address, qry_Ma7adir_karar_7abes_9.Register_Number, qry_Ma7adir_karar_7abes_9.Jorom, qry_Ma7adir_karar_7abes_9.Telegram_Number_1, qry_Ma7adir_karar_7abes_9.Telegram_Date_1, qry_Ma7adir_karar_7abes_9.Punishment, qry_Ma7adir_karar_7abes_9.NNumber, qry_Ma7adir_karar_7abes_9.DDate, qry_Ma7adir_karar_7abes_9.Report_Number_1, qry_Ma7adir_karar_7abes_9.Report_Date_1, qry_Ma7adir_karar_7abes_9.Amount_Text, qry_Ma7adir_karar_7abes_9.Penalty_Text, qry_Ma7adir_karar_7abes_9.Type, qry_Ma7adir_karar_7abes_9.Punish, qry_Ma7adir_karar_7abes_9.Judge_Name, qry_Ma7adir_karar_7abes_9.Status_Check, qry_Ma7adir_karar_7abes_9.M_ID, qry_Ma7adir_karar_7abes_9.M_Line1, qry_Ma7adir_karar_7abes_9.M_Line2, qry_Ma7adir_karar_7abes_9.Money_To_Jail, qry_Ma7adir_karar_7abes_9.S_ID, qry_Ma7adir_karar_7abes_9.T_ID, qry_Ma7adir_karar_7abes_9.T_Number, qry_Ma7adir_karar_7abes_9.T_Date, qry_Ma7adir_karar_7abes_9.Report_Status_1, qry_Ma7adir_karar_7abes_9.Printing_Date_001, qry_Ma7adir_karar_7abes_9.Day_Name, qry_Ma7adir_karar_7abes_9.Month_Name, tbl_Years.Year_Number_Text, tbl_Days.Day_Number_Text, qry_Ma7adir_karar_7abes_9.Printing_Date_002, qry_Ma7adir_karar_7abes_9.Day_Name_02, qry_Ma7adir_karar_7abes_9.Month_Name_02, tbl_Years2.Year_Number_Text, tbl_Days2.Day_Number_Text
FROM (((qry_Ma7adir_karar_7abes_9 INNER JOIN tbl_Years2 ON qry_Ma7adir_karar_7abes_9.Year_Number_02 = tbl_Years2.Year_Number_02) INNER JOIN tbl_Days2 ON qry_Ma7adir_karar_7abes_9.Day_Number_02 = tbl_Days2.Day_Number_02) INNER JOIN tbl_Years ON qry_Ma7adir_karar_7abes_9.Year_Number = tbl_Years.Year_Number) INNER JOIN tbl_Days ON qry_Ma7adir_karar_7abes_9.Day_Number = tbl_Days.Day_Number;

and this query is the source of a report when i open the report i'm getting this error message

The Specified field 'qry_Ma7adir_karar_7abes_99.tbl_Years.Year_Number_Text" could refer to more than one table listed in the FROM clause of your SQL statement.

any help???

 

[Uncle Gizmo]

hello it's me again

i have a query

SELECT qry_Ma7adir_karar_7abes_9.IDD, qry_Ma7adir_karar_7abes_9.Register_Date, qry_Ma7adir_karar_7abes_9.P_ID, qry_Ma7adir_karar_7abes_9.Name_Ma7dar, qry_Ma7adir_karar_7abes_9.Full_Name, qry_Ma7adir_karar_7abes_9.Mother, qry_Ma7adir_karar_7abes_9.Birthdate, qry_Ma7adir_karar_7abes_9.Nationality, qry_Ma7adir_karar_7abes_9.Record_Number, qry_Ma7adir_karar_7abes_9.Record_Place, qry_Ma7adir_karar_7abes_9.Address, qry_Ma7adir_karar_7abes_9.Register_Number, qry_Ma7adir_karar_7abes_9.Jorom, qry_Ma7adir_karar_7abes_9.Telegram_Number_1, qry_Ma7adir_karar_7abes_9.Telegram_Date_1, qry_Ma7adir_karar_7abes_9.Punishment, qry_Ma7adir_karar_7abes_9.NNumber, qry_Ma7adir_karar_7abes_9.DDate, qry_Ma7adir_karar_7abes_9.Report_Number_1, qry_Ma7adir_karar_7abes_9.Report_Date_1, qry_Ma7adir_karar_7abes_9.Amount_Text, qry_Ma7adir_karar_7abes_9.Penalty_Text, qry_Ma7adir_karar_7abes_9.Type, qry_Ma7adir_karar_7abes_9.Punish, qry_Ma7adir_karar_7abes_9.Judge_Name, qry_Ma7adir_karar_7abes_9.Status_Check, qry_Ma7adir_karar_7abes_9.M_ID, qry_Ma7adir_karar_7abes_9.M_Line1, qry_Ma7adir_karar_7abes_9.M_Line2, qry_Ma7adir_karar_7abes_9.Money_To_Jail, qry_Ma7adir_karar_7abes_9.S_ID, qry_Ma7adir_karar_7abes_9.T_ID, qry_Ma7adir_karar_7abes_9.T_Number, qry_Ma7adir_karar_7abes_9.T_Date, qry_Ma7adir_karar_7abes_9.Report_Status_1, qry_Ma7adir_karar_7abes_9.Printing_Date_001, qry_Ma7adir_karar_7abes_9.Day_Name, qry_Ma7adir_karar_7abes_9.Month_Name, tbl_Years.Year_Number_Text, tbl_Days.Day_Number_Text, qry_Ma7adir_karar_7abes_9.Printing_Date_002, qry_Ma7adir_karar_7abes_9.Day_Name_02, qry_Ma7adir_karar_7abes_9.Month_Name_02, tbl_Years2.Year_Number_Text, tbl_Days2.Day_Number_Text
FROM (((qry_Ma7adir_karar_7abes_9 INNER JOIN tbl_Years2 ON qry_Ma7adir_karar_7abes_9.Year_Number_02 = tbl_Years2.Year_Number_02) INNER JOIN tbl_Days2 ON qry_Ma7adir_karar_7abes_9.Day_Number_02 = tbl_Days2.Day_Number_02) INNER JOIN tbl_Years ON qry_Ma7adir_karar_7abes_9.Year_Number = tbl_Years.Year_Number) INNER JOIN tbl_Days ON qry_Ma7adir_karar_7abes_9.Day_Number = tbl_Days.Day_Number;

and this query is the source of a report when i open the report i'm getting this error message

The Specified field 'qry_Ma7adir_karar_7abes_99.tbl_Years.Year_Number_Text" could refer to more than one table listed in the FROM clause of your SQL statement.

any help???

qry_Ma7adir_karar_7abes_99

Is not part of your query.

 

[plog]

I'm sure he meant: qry_Ma7adir_karar_7abes_9

What happens when you try and run that query? Does it run fine or do you get the error there as well?

 

[Uncle Gizmo]

Well I formated the SQL string so that it was readable:-

'Q1. 'qry_Ma7adir_karar_7abes_9. (45)
'T1. 'tbl_Years. (2)
'T2. 'tbl_Days. (2)
'T3. 'tbl_Years2. (2)
'T4. 'tbl_Days2. (2)

'The Specified field 'qry_Ma7adir_karar_7abes_99.T1.Year_Number_Text"


'SELECT Q1.IDD, Q1.Register_Date, Q1.P_ID, Q1.Name_Ma7dar, Q1.Full_Name,
'Q1.Mother, Q1.Birthdate, Q1.Nationality, Q1.Record_Number, Q1.Record_Place,
'Q1.Address, Q1.Register_Number, Q1.Jorom, Q1.Telegram_Number_1, Q1.Telegram_Date_1, Q1.Punishment,
'Q1.NNumber, Q1.DDate, Q1.Report_Number_1, Q1.Report_Date_1, Q1.Amount_Text, Q1.Penalty_Text, Q1.Type,
'Q1.Punish, Q1.Judge_Name, Q1.Status_Check , Q1.M_ID, Q1.M_Line1, Q1.M_Line2, Q1.Money_To_Jail,
'Q1.S_ID, Q1.T_ID, Q1.T_Number, Q1.T_Date, Q1.Report_Status_1, Q1.Printing_Date_001, Q1.Day_Name,
'Q1.Month_Name, T1.Year_Number_Text, T2.Day_Number_Text, Q1.Printing_Date_002, Q1.Day_Name_02,
'Q1.Month_Name_02, T3.Year_Number_Text, T4.Day_Number_Text
'FROM (((qry_Ma7adir_karar_7abes_9
'INNER JOIN T3 ON Q1.Year_Number_02 = T3.Year_Number_02)
'INNER JOIN T4 ON Q1.Day_Number_02 = T4.Day_Number_02)
'INNER JOIN T1 ON Q1.Year_Number = T1.Year_Number)
'INNER JOIN T2 ON Q1.Day_Number = T2.Day_Number;