Joint query

[endri81]

Need to create a query which selects all enrolled students from table table "enrolled" and insert a new calculated field as follows:
MarkUK: Mark-EU*0.7

Regards

 

[plog]

Sounds like you have everything you need, what's the issue?

 

[endri81]

Just cannot manage a query to make both operations same time.
Can you please provide an example?
Regards

 

[plog]

An example of what? You've basically written all that needs to be done. Walk me through what you have actually done to produce this query and where specifically you are stuck.

 

[Galaxiom]

You are looking for something too complex.

All that is required is a bog standard select query with Enrolled as a criteria.

Then put this in the Field cell of an empty column in the designer:
MarkUK: Mark-EU*0.7