Hi, I am using vb2005 with access database and I have a crystal report which I want to preview and print only the last saved record. How can I do it?
Can any one help me with sample code
vijaycare
0
Newbie Poster
Recommended Answers
Jump to PostI'm not all that familiar with Crystal Reports, but I'm guessing that you still need to query the database.
Here's how:
SELECT TOP 1 * FROM (SELECT * FROM <table> ORDER BY id ASC)This syntax is necessary in an access database in order for the query to be …
All 4 Replies
Oxiegen
88
Basically an Occasional Poster
Featured Poster
vijaycare
0
Newbie Poster
Oxiegen
88
Basically an Occasional Poster
Featured Poster
vijaycare
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.