Probably a stupid question, but.....
Given: rScheduled is a field in the "Tests" table, "classes" is a seperate table and "cDate" is a field in the "classes" table.
What does this mean in a query?
rScheduled:[classes]![cDate]
Thanks
Probably a stupid question, but.....
Given: rScheduled is a field in the "Tests" table, "classes" is a seperate table and "cDate" is a field in the "classes" table.
What does this mean in a query?
rScheduled:[classes]![cDate]
Thanks
-----------------------------------------------------------------------------------------------------------------------------
Do all three tables appear in the query?
The syntax which you quoted is normally used for creating a calculated value in a query. I would expect that the field rScheduled in table Tests is being set equal to field cDate in table classes. However, without considering the any defined relationships and the query itself, I can't guarantee that is what is really happening. Perhaps one of the other gurus on this forum can give you such a guarantee.
Presuming that's in design view, it's creating a new field called rScheduled using the cDate field from classes. If rScheduled is a field name in another table, it was likely a poor choice of names for the alias given the confusion that could result.
It is in design view, but it shows up in SQL as well.
Are you saying that it is similar to "select classes.cdate AS rScheduled" ?
Not just similar. This:
rScheduled:[classes]![cDate]
is the design view equivalent of the SQL:
classes.cdate AS rScheduled
awesome, thanks. I'm trying to teach myself but sometimes it gets confusing.