Queries

Paste errors when copying column name in a group by function
I have this really strange and annoying problem when using a group by in a query. To avoid names like sumOffTotalVolume I try to copy the file name 'Total Volume' typ":" to get these result; Total Volume: Total Volume This is clear I think. What happens very often that instead of the copied data, copied data... 25 Jun 2008 06:46

Different results in SQL and Access
Hi Everyone, When I run the query Select a,b,c from mytable where trandate >= #20/06/2008 00:00:01# and trandate <= #20/06/2008 23:59:59# and (trantype = "OP" or trantype = "NP); in SQL Server, I get the result of 145,309 rows selected in MS-Access, with a table Linked to the SQL Server table, I get the resul... 1 Jul 2008 08:13

Operation must use an updateable query.
I keep getting this error whenever I run my ASP page Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /usergroup/addtodbase.asp, line 37 I've searched about this error in the internet but I can't find the answer. The Folder where the database is located have Read/W... 25 Jun 2008 18:06

How do I set Reverse Joins in Access 2007?
During training we were told about Reverse Joins. I don't find this in Access 2007. Anyone know if it was taken out? I am trying to run a report with all names from one table even if the names are not in the second table, and vice versa. ... 25 Jun 2008 11:54

How to make update a field of a table
If you mean this = '" & Me.[V File Number] & "' That is good to know. The problem is that if I remove this I get a "data miss match" error. ... 25 Jun 2008 10:52

Update query help
I am just learning to use queries and the book I am learning from ask for an update query to increase the list price of all products for 'supplier A' by 3.25. I wrote the following update query but it give a 'type mismatch in the critera expresion' error. UPDATE Products SET [List Price] = [List Price] + 3.25... 25 Jun 2008 09:51

Running Sum in a Query
I am struggling with the DSum function in a query. I have 4 fields and want to calculate a Running Sum in the last column of the query. Number Group Subgroup Pct RunSum ABC123 115 500 1.022 ABC345 115 500 .052 ABC765 ... 25 Jun 2008 04:44

Full text not showing in report
I had a similar problem with the full text from a memo field not showing up in a report I made. I wish I could say why it didn't work, but I found that if I put it in the Page header or footer the full text was not displayed. I'll have to dig up the program and find out where I ended up putting the memo field, but see... 24 Jun 2008 20:34

Access Query not working properly
Hi I have the following query that i am trying to make it work: SELECT [MS Incidents May-June 08].[Contract #], [MS Incidents May-June 08].[Product Level 2] FROM [MS Incidents May-June 08] INNER JOIN [MS Incidents May-June 08] AS [MS Incidents May-June 08_1] ON [MS Incidents May-June 08].[Contract #] = [MS In... 24 Jun 2008 19:32

Update Query for Current Record Only
I have an update query which I want to run when a record is given focus in a form. But I do not know how to reference this either in the event property or the query itself so that the query does not update all the records in the target table. Can anyone else? ... 26 Jun 2008 08:25