Skip to search.
MS_Access_Professionals · MS Access Professionals
  • Members Only
  • Post
  • Files
  • Photos
  • Links
  • Database
  • Calendar
  • Groups Labs (Beta)

Group Information

  • Members: 4848
  • Category: Microsoft Access
  • Founded: Mar 29, 2002
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.
Notice  Upcoming calendar upgrade: Yahoo! Groups calendars are being upgraded to a much improved version. You may not have access to the calendar (for up to 24 hours) when this group is upgraded. We sincerely apologize for this inconvenience.

Home

  

Activity within 7 days:

185 New Messages - 2 New Files

Description

SPAM-FREE advice and knowledge pool for beginners through advanced users of Microsoft Access and databases in general.

Please Note: New Members will have their posts moderated for a period of time so we can be sure you are a real member and not a spammer. Sorry for the inconvenience.


Please Note: We do not allow job postings or recruiting at this site. Doing so will only get you banned.


Whether you are seeking help in database design, user interface, complex MS Access VBA code, MS SQL Server, we can help.

Our membership includes several MS Access MVPs and posts average over 800 a month! Our Archive contains many sample databases, Utilities, Add-ins, code samples and more.

Share your knowledge and it will come back to you ten-fold!

For more accurate answers, please indicate which software version you are using when asking a question.

Most Recent Messages

  (View All)
(Group by Topic)
Search:
Advanced
    Start Topic
Re: Repair on DB open?
I've only had preliminary conversations with the new client, but my understanding is that there's a "replication master" in Canada which is used to coordinate
Posted - Sun May 27, 2012 9:51 pm
 Sigurd Andersen
sigurd1999
Offline Offline
Send Email Send Email
Re: Finding Poverty Levels
John, Perfect as Always. With warm regards, Arthur Lorenzini Sioux Falls, South Dakota ________________________________ From: John Viescas <JohnV@...> To:
Posted - Sun May 27, 2012 8:25 pm
 Art Lorenzini
dbalorenzini
Offline Offline
Send Email Send Email
Re: Finding Poverty Levels
Art- It's a simple matter to insert the expression I gave you: SELECT tblApplicationHousehold.ApplicationID, Count(tblApplicationHousehold.HouseholdID) AS
Posted - Sun May 27, 2012 7:57 pm
 John Viescas
jlviescas
Offline Offline
Send Email Send Email
Re: Finding Poverty Levels
John, this is the SQL now:   SELECT tblApplicationHousehold.ApplicationID, Count(tblApplicationHousehold.HouseholdID) AS NoPersons,
Posted - Sun May 27, 2012 7:30 pm
 Art Lorenzini
dbalorenzini
Offline Offline
Send Email Send Email
Re: Finding Poverty Levels
Art- Tough to say. You could decide on a threshhold amount, perhaps $2000, and avoid the multiply. What's the SQL of your "fixed" query? It would take an
Posted - Sun May 27, 2012 5:32 pm
 John Viescas
jlviescas
Offline Offline
Send Email Send Email
Add MS_Access_Professionals to your personalized My Yahoo! page Add to My Yahoo! XML What's This?

Message History

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2012 1018 643 528 664 582
2011 808 577 702 681 667 685 662 605 600 696 951 739
2010 749 762 762 766 717 721 601 796 769 908 713 805
2009 952 995 778 883 883 1157 833 576 516 520 851 743
2008 1188 1203 936 1069 927 1193 977 955 1361 1107 876 762
2007 1313 888 940 790 950 950 901 1051 899 936 824 809
2006 1133 908 1101 974 1210 1101 1023 1156 733 1241 857 1014
2005 771 877 1286 981 1029 781 829 739 649 578 940 853
2004 824 633 793 945 879 758 1006 900 1150 1245 1094 618
2003 473 596 873 694 784 675 695 781 708 810 874 686
2002 18 142 200 226 348 307 237 358 380 346
Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help