Welcome to WebmasterWorld Guest from 184.72.177.182

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)

New User

joined:Apr 5, 2011
posts: 6
votes: 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)

Senior Member

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

joined:Nov 12, 2005
posts:5966
votes: 0


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)

New User

joined:Apr 5, 2011
posts: 6
votes: 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)

Senior Member

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

joined:Nov 12, 2005
posts:5966
votes: 0


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)

New User

joined:Apr 5, 2011
posts: 6
votes: 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)

New User

joined:Apr 5, 2011
posts: 6
votes: 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)

New User

joined:Apr 5, 2011
posts: 6
votes: 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)

New User

joined:Apr 5, 2011
posts: 6
votes: 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)

Senior Member

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

joined:Nov 12, 2005
posts:5966
votes: 0


Glad everything is sorted out.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members