Can't get this query to work...

  • Thread starter Thread starter Brady Snow
  • Start date Start date
B

Brady Snow

I can get this query to work in Access but when I try to
compile it in a form is doe not compile. Here is the
query:

strSQL = "SELECT MixDesignID.PlantID, MixDesignID.MixID,
MixDesignID.StoneName, MixDesignID.StoneWt " &_
"FROM (MixDesignID INNER JOIN PlantID ON
MixDesignID.ID = PlantID.ID) INNER JOIN StoneID" &_
"ON (MixDesignID.ID = StoneID.ID)" &_
"WHERE (((MixDesignID.PlantID)= " & ME.PlantID &_
") AND ((MixDesignID.MixID)= " & ME.MixID & "))"


Any help would be greatly aappreciated!

Regards,

Brady Snow
Mckinney, Texas
 
Try adding as space after the ampersand and before the
underscore at the end of your lines.

Another suggestion is to create the query in the query
builder of Access then go to the SQL view of the query and
copy that to your form_current() action.
 
Back
Top