General
in [Access]
|
dcount I would like to use the values in dcount to perform another calculation. I counted two sets of records and would like to divide the two numbers to give a percent. For example =dcount("[pass]","GED results","[pass]='y'")/=dcount("form3]","ged results") -- ts ... 29 May 2010 22:18
List of values summing to a known value Is it possible to run a query that would return a list of values that sum to a known quantity. A simplified example would be as follows: Return any items from the list that sum to 10 1 3 4 7 9 The returned values would be 1,9 and 3,7. Thanks. ... 1 Jun 2010 14:12
Changing field names Hi I have a database which I'm trying to clean up with appropriate names. It is problematic for example I changes Intake Coordinator to Primary Worker and Due Date to Closed Date etc... So the problem is that now the reports have the new fields but the old fields are poping up . So I changed the field in the re... 28 May 2010 17:05
Final Reminder - Microsoft Responds to the Evolution of Community Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of Office. Office 2010 is all about making it easy for you to get and use Office on your terms. Office 2010 lets you work from the office, from home, or at s... 28 May 2010 12:40
Displaying dates by weeks in Report I have to display data by weeks in a report. What is the best way to do it? weeks 5/24/2010 - 5/28/2010 5 time sheets returned ... 2 Jun 2010 14:16
Which forum or website are the regulars switching to? Just wondering where all the regulars are going to when the access related newsgroups shut down? I have never used a Microsoft Forum, I guess I could switch to utteraccess? I always found these newsgroups better and easier to use. Mark Andrews RPT Software http://www.rptsoftware.com http://www.donationman... 30 May 2010 14:21 |