No announcements
Found 2655227 threads
-
0 VotesRuntime Error 3000 when using Crosstab Query as Recordset
crosstab query to a table, or utilize it as a recordset in VBA, this would be a super-simple thing to do. I'll keep looking. Thanks ...Unanswered | 5 Replies | 1741 Views | Created by LadyPhoenix - Wednesday, December 12, 2012 6:03 PM | Last reply by LadyPhoenix - Monday, December 17, 2012 2:11 PM
-
2 Votes
Crosstab query from open recordset
Hello Is there a way to create a crosstab query from an open recordset in VBA? Here is my code: strSQL = ...Answered | 4 Replies | 2784 Views | Created by Shike Marples - Thursday, September 20, 2012 10:08 PM | Last reply by Shike Marples - Friday, September 21, 2012 3:20 PM -
1 Votes
runtime error 3000 Reserved error(-1524)
Qry runs as always,among some other queries in my code) I get the following message: runtime error 3000 Reserved ...Answered | 3 Replies | 5833 Views | Created by Earl yeah OK - Thursday, February 21, 2013 3:03 PM | Last reply by Bruce Hulsey - Thursday, February 21, 2013 3:43 PM -
2 Votes
Crosstab Query
Explain a little more about how the heading names change. There are ways to do dynamic crosstab queries using queries ahead of the ...Answered | 6 Replies | 402 Views | Created by Gordon Swan - Saturday, July 29, 2017 11:49 PM | Last reply by .theDBguy - Thursday, August 3, 2017 5:45 PM -
0 Votes
Crosstab query error that uses a parameter
Currently using CR bundled with VS 2005. I'm trying to create a report off an access crosstab query that uses one parameter. In the field ...Unanswered | 0 Replies | 4744 Views | Created by wiu joe - Tuesday, February 7, 2006 10:03 PM | Last reply by wiu joe - Tuesday, February 7, 2006 10:03 PM -
0 Votes
UpdateCommand on Crosstab Query
I have a datagridview that is bound to a crosstab query: SQL: TRANSFORM First(ProductGroups.GroupId) AS ... -
0 Votes
Crosstab Query issue
I have a crosstab query which is giving me the following error The Microsoft Access database engine does not recognize '[Start Date ...Answered | 3 Replies | 1487 Views | Created by Myysterio - Wednesday, March 13, 2013 3:25 PM | Last reply by Myysterio - Wednesday, March 13, 2013 5:19 PM -
0 Votes
Crosstab Query
Hi, I am trying to replicate an access crosstab query I have use PIVOT but this is not working as this requires an aggregate ...Answered | 4 Replies | 1313 Views | Created by JohnJames55 - Sunday, May 18, 2014 10:07 AM | Last reply by JohnJames55 - Sunday, May 18, 2014 7:52 PM -
0 Votes
Crosstab query question
I have the following crosstab query TRANSFORM First(QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.Value) AS ...Answered | 1 Replies | 131 Views | Created by tkosel - Thursday, January 4, 2018 7:17 PM | Last reply by tkosel - Thursday, January 4, 2018 7:23 PM -
0 Votes
ADO, VB and crosstab query
Hi, well I'm using VB and Access as the db. I have made a crosstab query in Access and it's work well, but when I do the same in ...Answered | 2 Replies | 4160 Views | Created by nmxnmx - Friday, November 24, 2006 6:58 PM | Last reply by nmxnmx - Friday, November 24, 2006 7:17 PM -
0 Votes
PIVOT Query (Crosstab Query)
I just wnated to know does SQL Server 2012 or 2008 support PIVOT query. I need to use many CASE statement to complete PIVOT query using SQL Server ...Answered | 1 Replies | 3223 Views | Created by sourises - Friday, November 9, 2012 8:54 PM | Last reply by sourises - Friday, November 9, 2012 10:23 PM -
0 Votes
crosstab query
Try this: SELECT Call.CallDate, HospitalNames.DestinationHospitalName, COUNT(CASE WHEN DATEPART(mm,CallDate) = 1 THEN CallDate END) as ...Answered | 4 Replies | 3589 Views | Created by Ryanls - Monday, June 7, 2010 3:39 PM | Last reply by Ryanls - Monday, June 7, 2010 4:55 PM -
2 Votes
visual foxpro crosstab query
crosstab query in my application it generate error "File does not exist" ,when I run this query from vfp6 command ...Answered | 4 Replies | 1576 Views | Created by Irshad Zia - Saturday, May 17, 2014 6:07 AM | Last reply by Naomi N - Tuesday, May 20, 2014 2:38 AM -
0 Votes
Microsoft Access Crosstab Query
Hi, I'm looking to create columns in my crosstab query which will contain all of the dates for a given year - ...Answered | 2 Replies | 3876 Views | Created by jamesescott08 - Thursday, July 7, 2011 10:30 AM | Last reply by QA Guy CommElec - Thursday, July 7, 2011 2:37 PM -
0 Votes
Crosstab Query on a saved query
back to your question, you can not crosstab on a "text file".. but you can perhaps perform a crosstab query on a registered database's ...Answered | 1 Replies | 4904 Views | Created by EAB1977 - Monday, November 17, 2008 7:30 PM | Last reply by Andrea Montanari - Tuesday, November 18, 2008 1:12 AM -
4 Votes
Define Query Field As A Recordset
for a long time. This should have been so easy. Using a recordset based on a query (that is already a recordset). Instead, as I ...Answered | 9 Replies | 2529 Views | Created by Lawrence Ellefson - Thursday, July 5, 2012 7:09 PM | Last reply by Joshua Honig - Friday, July 6, 2012 12:49 AM -
0 Votes
Crosstab query
WHEN T.Site = 'Site A' THEN T.QtySold END) AS [Site AAnswered | 7 Replies | 3926 Views | Created by Halim1973 - Wednesday, July 6, 2011 2:43 PM | Last reply by Halim1973 - Thursday, July 14, 2011 8:20 PM -
0 Votes
Editable crosstab query?
Is it possible to have 5 successive records displayed in a query/form similar to a crosstab but editable. I have a Projects table with 5 ...Answered | 5 Replies | 4278 Views | Created by SpaceData - Sunday, February 19, 2012 11:31 PM | Last reply by SpaceData - Monday, February 20, 2012 8:27 PM -
0 Votes
Recordset query
Arteta 8 I can get the query to run from vba with this code: Dim db As ...Answered | 1 Replies | 592 Views | Created by Daddydoop - Friday, September 26, 2014 9:53 PM | Last reply by Fei Xue - Monday, September 29, 2014 8:54 AM -
2 Votes
Crosstab Query Drops Row
Hello John. A crosstab query uses a grouping query to build the row headers, so if you use something like a CustomerID to summarize records from an Orders ...Answered | 4 Replies | 3577 Views | Created by John Lane - Saturday, December 4, 2010 3:17 PM | Last reply by Vanderghast - Tuesday, December 7, 2010 11:57 AM - Items 1 to 20 of 2655227 Next ›
No announcements
