Calculating Percentage in Query.33061 (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.72228 (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 disk52560 (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 sure82925 (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)12277 (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/year13328 (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 criteria23589 (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?03028 (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 messages12628 (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 ... Utf