plantfinder
Registered User.
- Local time
- Today, 00:48
- Joined
- Sep 28, 2002
- Messages
- 12
I have a report based on a query that includes 3 tables. "Plant" is one table and "Photos" are another.In some cases, there can be multiple photos per plant record.In the query that runs this report I have some records that are duplicated in that there may, in some cases, be mutiple photos for the same record(which is basically of a plant). The "photos path" field comes from a separate (related) table from the Plant Infomation Plant There may be more than one photopath for each plant. I really only want and need to have just one of the records that relates to a specific plant ID#s show in the report with just one of the photos. It could be the first photo listed for that plant or any one. Is there some way I can enter some criteria in the query to keep only one record i.e 1 (unique) plant ID # showing up in the results and to pull out one photopath record that relates to it? I'm guessing this may need some clarification. Would "Dfirst" do anything? I'm guessing or is there a better way?
PS. Can we do this without using VB?
Thanks Mike
PS. Can we do this without using VB?
Thanks Mike