How do you keep track of your gift certificates? I can'r seem to get a report that tells me who bought what NUMBER certif. I can get a report that tells me who bought a certif, but not what # I also seem to have odd gaps when I go back and pull a copy of each certificate. any help?

By number are you referring to the number that the seller can type in to refer to the Gift Certificate when selling it? Are you using Gift Certificates in such a way that Patron Edge will know if it has been used or not? If so I may have a report that can help you. I cannot see my report right now, but can have a look at the office tomorrow! I am also wondering what you mean by "I also seem to have odd gaps when I go back and pull a copy of each certificate." Good Luck! Shannon Detroit Symphony Orchestra

After looking at my report and query, I am using this query (the dates are whatever the user enters into crystal). All my Gift Certificates have the word gift in them and nothing else has that word so I am filtering that out also. the vcRefundNumber is the number that would be used in the system at the time of sale. Hopefully that will get you started! Shannon SELECT Vouchers.vcRefundNumber, Vouchers.vcStatus, Vouchers.vcSum, Vouchers.vcName, Vouchers.vcSurName, Vouchers.vcIssueDate, Vouchers.vcRedemptionDate, Vouchers.vcExpiryDate, Vouchers.vcClientGroupCode, Clients.cltGroupCode, Clients.cltCode, Clients.cltIsGroupLeader, Clients.cltSurName, Clients.cltFirstName, MerchandiseItems.mitShortDescr, MerchandiseItems.mitDescr FROM Vouchers Vouchers INNER JOIN Clients Clients ON Vouchers.vcClientGroupCode = Clients.cltGroupCode INNER JOIN Merchandise Merchandise ON Vouchers.vcMerchId = Merchandise.mcdCode INNER JOIN MerchandiseItems MerchandiseItems ON Merchandise.mcdItemCode = MerchandiseItems.mitCode WHERE (Vouchers.vcIssueDate >= CONVERT(DATETIME, '2006-08-09 00:00:00.00', 102)) AND (Vouchers.vcIssueDate < CONVERT(DATETIME, '2007-08-10 00:00:00.00', 102)) AND (MerchandiseItems.mitShortDescr LIKE '%gift%') AND (Clients.cltIsGroupLeader = 1)