homepage Welcome to WebmasterWorld Guest from 54.211.100.183
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Access database count of items query
How to do this with aspx?
luvfords



 
Msg#: 4292182 posted 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

 

eelixduppy

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



 
Msg#: 4292182 posted 6:49 pm on Apr 5, 2011 (gmt 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.

luvfords



 
Msg#: 4292182 posted 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.

eelixduppy

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



 
Msg#: 4292182 posted 8:00 pm on Apr 5, 2011 (gmt 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...]

luvfords



 
Msg#: 4292182 posted 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

luvfords



 
Msg#: 4292182 posted 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

luvfords



 
Msg#: 4292182 posted 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.

luvfords



 
Msg#: 4292182 posted 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.

eelixduppy

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



 
Msg#: 4292182 posted 2:15 pm on Apr 7, 2011 (gmt 0)

Glad everything is sorted out.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved