autogenerate nos in vb.net

[aarti83]

hello,

i m developing a small project.
but i m having some problems in that.
plz if any one can help i will be very thankfull.

i m using access as backend.
1)i want to auto generate nos in ID....it should be autogenerate from the last no in database.

2) how to collect data between two dates.

3)calculate the total amount....income of the day from no og bill placed in that day.

plz help me.

[r035198x]

hello,

i m developing a small project.
but i m having some problems in that.
plz if any one can help i will be very thankfull.

i m using access as backend.
1)i want to auto generate nos in ID....it should be autogenerate from the last no in database.

2) how to collect data between two dates.

3)calculate the total amount....income of the day from no og bill placed in that day.

plz help me.

Hi and welcome to TSDN. Hope you'll have a great time here.
I've moved this to the .NET froum

[dip_developer]

hello,

i m developing a small project.
but i m having some problems in that.
plz if any one can help i will be very thankfull.

i m using access as backend.
1)i want to auto generate nos in ID....it should be autogenerate from the last no in database.

2) how to collect data between two dates.

3)calculate the total amount....income of the day from no og bill placed in that day.

plz help me.

1. There is a AutoNumber DataType in Access......use it for a autonumber field.....The number will increase as the data will be inserted......

2.You have to write sql query like following to collect data between two dates......
SELECT trans_id,trans_date,bill_no FROM tblTransaction Where
trans_date BETWEEN #05/05/2005# AND #05/05/2007#

3.For total amount you have to again write the proper query like....

SELECT SUM(bill_amount) FROM myTable WHERE bill_date=DATE()

the DATE() function returns the current date in ACCESS