J
JoeM
I have a list of data in a database(access). How can I get the total rows
in the database?
Thanks
in the database?
Thanks
I have tried that it will count the columns without
any trouble, but I need to count the rows.
I have 2 columns Customer ID and Name, I need to get
the either the last customerID or how many entries
are in the data base.
Example:
CustomerID Name
1 James
2 John
3 Adam
4 Jason
I would need to pull the last customerID. The numbers
will increase and are unknown when trying to get the
ID.
JoeM said:I have tried that it will count the columns without any trouble,
but
I need to count the rows.
I have 2 columns Customer ID and Name, I need to get the either the
last customerID or how many entries are in the data base.
Example:
CustomerID Name
1 James
2 John
3 Adam
4 Jason
I would need to pull the last customerID. The numbers will increase
and are unknown when trying to get the ID.
First of all, let's get your terminology straight: a "database" is a
collection of tables which are collections of rows and columns of data.
Thanks I had some lines mixed up, the code works, Thank you
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.