Welcome to WebmasterWorld Guest from 54.159.179.132

Forum Moderators: open

Message Too Old, No Replies

Access database count of items query

How to do this with aspx?

   
4:06 am on Apr 5, 2011 (gmt 0)



I have an Access database which formerly ran with FP, and a web bot that gave the count of a particular field, for instance 25000 then when another item was added that count changed to 25001. It only worked on an old FP .asp page.

Now I want to achieve similar results on an .aspx page by Expression Web 4. Does anyone know of a query or web bot which will do this?

Thank You.
John
6:49 pm on Apr 5, 2011 (gmt 0)

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 5+ Year Member



Welcome to WebmasterWorld, John!

Try this search for help on querying an access database: [google.com...]

Then once you can connect to your access table, you have to query it using the count() aggregate function. See if you can't implement this yourself, and if you still need help feel free to ask.
7:56 pm on Apr 5, 2011 (gmt 0)



Thanks for the suggestion.... all I get when I click on the link is Google, I guess the problem I have been having is that I do not know how to search for it in Google. I see there is a long link here, but as I said it does nothing except to go to the Google page, maybe I am missing something obvious... I get the impression it was a structured Google search there? I believe if I have the query I can implement it as I seem to do OK with others.
8:00 pm on Apr 5, 2011 (gmt 0)

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 5+ Year Member



Apologies, been on leave for awhile it seems the URL redirect script does not allow links to google searches any longer. Try this:

[webwiz.co.uk...]
8:02 pm on Apr 5, 2011 (gmt 0)



What I meant was.... I know how to use Google, I do not know how to ask for what it is I am looking for, concisely and correctly. So maybe I need help in asking the question, too.
John
8:27 pm on Apr 5, 2011 (gmt 0)



Yes, that page will of immense help to me! I will study it tonight when I get home. Thank you very much.
John
9:04 pm on Apr 5, 2011 (gmt 0)



Reading that page you suggested helped me formulate what I wanted to ask, and I quickly found this SQL help page: [techonthenet.com...]
Maybe someone else can use its advice too.
8:37 pm on Apr 6, 2011 (gmt 0)



I was successful in finding what I needed it really is not a complicated query but without the help of this Forum I could not get my needs properly stated. Thanks for your assistance.
2:15 pm on Apr 7, 2011 (gmt 0)

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 5+ Year Member



Glad everything is sorted out.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month