quote:

---

Originally posted by JanetSm:
Hi all, i was wondering the best way to integrate an access query into my FP web page. I have a query in access which allows me to query two tables joining on a common field. I really want to know how to call this query. I tried copying the SQL from access and pasting it into the DRW but i received errors. Where should i go from here?

---

Here's a query I use in the custom query dialog box. Check your syntax to see if it's similar to mine:

SELECT parts.parts, parts.vendor, Buyer.name, Buyer.extension, Buyer.code
FROM Buyer INNER JOIN parts ON Buyer.code = parts.code
WHERE ((([parts]![product])='Motor'))
ORDER BY parts.parts;

Hope this helps.

------------------
Matt Harris
Senior I.E.
Matt_R_Harris@Baldor.com

ie

Select * from Query

As opposed to

Select * from table

If it exists as a query in ACCESS, you can use that as a source in FP

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!