S ScottBeatty Registered User. Local time Today, 02:33 Joined May 31, 2013 Messages 65 Jun 5, 2013 #1 I have a report already made but is it possible to import only one record from a query?
C CJ_London Super Moderator Staff member Local time Today, 07:33 Joined Feb 19, 2013 Messages 17,759 Jun 5, 2013 #2 write your query to only return one record - perhaps using group by, or select distinct or select top 1 or select first/last. Will depend on your query as to which is the way to go
write your query to only return one record - perhaps using group by, or select distinct or select top 1 or select first/last. Will depend on your query as to which is the way to go
