You could use (DLookup) instead of (IIf)

[azhar2006]

Hello all
What do I do??

I have a query based on two tables
This model is based on the query
Question


I can not add value in the fields on the form
But when you delete one of the tables, query and remains one table can be added here
What is the reason?
You could use (DLookup) instead of (IIf)
Please help me
-----------------------------------------------------------------
SELECT [TotalScores]/7 AS Expr1, IIf([Expr1]>=[Params1],[Computer],IIf([Expr1]>=[Params2],[Maths],IIf([Expr1]>=[Params3],[Statistics],IIf([Expr1]>=[Params4],[Medical]," ")))) AS Field, Right([yars],2) & "" & [NoAccepCentral] & "" & [field] AS Expr2, [Field] AS uu, tbStudents.StuID, tbStudents.NoAccepCentral, tbStudents.yars, tbStudents.StudentName, tbStudents.FigAla, tbStudents.City, tbStudents.HighSchool, tbStudents.Branch, tbStudents.TotalScores, tbStudents.University, tbStudents.Computer, tbStudents.Maths, tbStudents.Statistics, tbStudents.Medical, Table2.Params1, Table2.Params2, Table2.Params3, Table2.Params4
FROM tbStudents, Table2;

[June7]

There is no JOIN clause. These tables do not have a relationship. I don't think DLookup will work either. There is no way to determine which record in Table2 should be linked to each record in tbStudents.

What is nature of data in Table2?

Are those semi-colons actually working? I get an error when I try to use semi-colon.

[azhar2006]

Yes, thank you
It's Digital
I am using this expression in the picture works well
I have you put this expression
But over time this changes the arithmetic mean
I do not want the school administration every season come back to me
The model developed here would be controlled by the teacher in the calculation of these rates

[June7]

Need to save the ID of record from Table2 into a field in tbStudent. Then join the tables in query on those key fields. Then the associated Params fields are available for the expression in query.

[azhar2006]

Thank you very much
How is it possible to explain more
Or attach an example
I will be very happy

[June7]

Are there multiple records in Table2? Must have a field in tbStudents to save the ID of a Table2 record. There must be a relationship between the tables.

You did not answer my question of what data is in Table2.

What is Table1 for? Why does it not have a relationship with any other table?

The links shown in the image are not between primary and foreign key fields. StuID should not be linked to SecID.

You need to get a better understanding of relational database principles. Maybe this will help http://www.rogersaccesslibrary.com/

[azhar2006]

Table 2
It's just numbers
As Table 1 is a scientific sections
Was transferred to the table tbStudents

[azhar2006]

The problem is
I can not change these numbers manually
But when you delete a table 2 of the query can I change those numbers