 |
MSGROUPS.NET |
 Search |
 Post Question |
 Groups |
 Stream |
 About |
 Register
|
Top Users in microsoft.public.access.queries  Sarella (1) 0 Articles, 1 Replies, 1 Points
Top Articles in microsoft.public.access.queries  Calculating Percentage in Query.  3
 3061 (7/11/2007 7:34:01 PM) I have a query with the fields Quantity (Count of ID's), Product, company. My issue is to calculate the percentage for each company in a query When I put Quantity/Sum(Quantity)) I am getting subquery warnin...   Utf Action Query (Append) didn't add records due to key violations. 7
2228 (3/18/2010 5:54:02 PM) Hi all, I am using MS Access 2007 as front-end and SQL Server 2005 as back-end. In SQL Server I have a PK plus a multi-field index that is unique. I can add records manually in both Access and SQL, but w... Utf Not enough space on temporary disk 5
2560 (10/1/2007 3:49:59 PM) When running a query in an access database 2000 mode in Access 2003 SP2 the following error message is displayed when the status bar is about half way. Not enough space on temporary disk I noticed the followi... Robin9876 "is not a valid name. Make sure 8
2925 (3/17/2010 2:42:01 PM) I just converted several my Access Databases to Access 2007 and I am getting the following error message on 2 of them: "is not a valid name. Make sure that it does not include invalid characters or punct... Utf in access, round up to nearest fraction(.5) 1
2277 (5/19/2010 5:49:01 PM) In MS-Access, How do I round a formula result up to the nearest fraction (Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7 rounds up to 2 ... Utf convert date field to month/year 1
3328 (2/21/2008 2:56:01 PM) Hello, I have a table with a date field. In query, I would like to convert the date field like mm/dd/yyyy to just the year and month. what function do I put to achieve this? PS. if the format is yy-mmm (08... Utf Access: exclude data from a query based on two criteria 2
3589 (6/27/2007 3:36:00 PM) Re: a query in Access. I want to exclude two descriptions in a field, i.e., I have a Division field and I want to exclude "void" and "voidbus". Help! ... Utf In Access 2010, how do I create a SQL query? 0
3028 (3/14/2010 11:20:01 AM) In older versions of Access, there was a View -> SQL View menu button. How do I get the SQL View with Access 2010? I need to create a query which contains a join operation. I don't think I can do this wi... Utf Turning off action query confirmation messages 1
2628 (2/19/2010 6:16:02 AM) How do I turn off ALL confirmation messages for make-table and append queries when running them from a macro in an Access 2007 .accdb database? I've tried following a 2004 posting which says: "If you're ... UtfStatistics Last Updated: 5/9/2013 12:00:00 AM |
16 followers. 