Show only Certain Report...Not all of it?

[peirob2006]

Hello,

I am somewhat familliar with the VB6 way of doing things (AKA haven't the foggiest clue)

I know how to create the DataReport in VB6 and How to Connect the Database....but...how do I make it so I can display only the last record added so I can print that one page and not all the other records in the Database?

And one more question simular in context....

How do I make it so I can also show only a specific range of information...in other words...show only records in the user defigned date range (Date is mm-dd-yyyy)

any help on either questions, that would be great,
Thank you in advance,

[sashi]

Hi there,

well.. kind of simple.. just follow the steps below.. good luck my fren..

1st..
create your table with a field named [id] or something like that, set the datatype to autonumber.. this will provide you sequential number.. rite??

2nd..
issue an SQL statement with [MAX] keyword by means to select maximum value from a specific field..

syntax..

SELECT MAX(expression ) FROM tables WHERE predicates;
 

sample usage..

SELECT MAX(ID) FROM tblName;
 

to select data in a defined range simple follow the step below..

syntax..

SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2
 

sample usage..

SELECT * FROM tblName WHERE 'search_criteria' BETWEEN 'date1' AND 'date2'
 

pls refer to the below attached link for further reading.. take care..

http://www.w3schools.com/sql/