expression builder - dilemma

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

Guest

I am producing a form which uses fields from record source "A" but also want
to refer to some data in record source QRY X.
I am trying to write an expression in the form which calls on data from the
query and using the the full expression [QRYX]![data] to refer to the data in
that qry but after hours of looking at online help and my access handbook, I
can not get it to work......Any help on this apparantly simple problem that I
am unable to work through would be much appreciated..
 
uh.. then join to the query?

you'd need to use views if you want to do this sort of thing


views rock


ADP Uber Alles
 
you just need to add the query to the sql statement-- do a join from your
existing query into the new query

you can't just bind a sql statement to a query, you've got to use real SQL
 
Back
Top