Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-30-2018, 05:49 AM   #1
Wolfroolz
Newly Registered User
 
Join Date: May 2015
Posts: 32
Thanks: 22
Thanked 0 Times in 0 Posts
Wolfroolz is on a distinguished road
Crosstab query sorting problem

I currently have a database that generates a dynamic report based on the dates they select as well as the class_id. To generate the report I use a crosstab query. The crosstab query is based on a query with the following fields: CCUST_ID, WEDate, Item_Type, Quantity, DESCRIPTION, Class_Type, Sort_Order

This generates a report with:
Cust ID(Group)
WE Date, Item1, Item2, Item3....etc

The data is in two tables:
Table - Item_Types: ITEM, MULTIPLE, INTERVAL, DESCRIPTION, Class_Type, Sort_Order
Table - Schedule: ID(autonumber), WEDate, Cust_ID, Item_Type, Quantity

I got everything to work except I can't figure out how to sort based on the sort order field. It automatically sorts it alphabetically, and that is not practical. I can't set the order manually because the fields change depending on the user input.

SQL of query below(the above examples were simplified to make easier reading)

Appreciate any help with this. Thanks.

PARAMETERS [Forms]![ReportSelector]![cmbType] Text ( 255 ), [Forms]![ReportSelector]![tStart] DateTime, [Forms]![ReportSelector]![tEnd] DateTime;
TRANSFORM Sum(qCust_Sched.Quantity) AS SumOfQuantity
SELECT qCust_Sched.CUST_ID, qCust_Sched.GROUP_DESC, qCust_Sched.CONTACT, qCust_Sched.PROJECT_TASK, qCust_Sched.LOCATION, qCust_Sched.TEL_NUMBER, qCust_Sched.SECT_CODE, qCust_Sched.WeekEndDate, Sum(qCust_Sched.Quantity) AS [Total Of Quantity]
FROM qCust_Sched
GROUP BY qCust_Sched.CUST_ID, qCust_Sched.GROUP_DESC, qCust_Sched.CONTACT, qCust_Sched.PROJECT_TASK, qCust_Sched.LOCATION, qCust_Sched.TEL_NUMBER, qCust_Sched.SECT_CODE, qCust_Sched.WeekEndDate
PIVOT qCust_Sched.Item_Type;

Wolfroolz is offline   Reply With Quote
Old 08-30-2018, 06:19 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,396
Thanks: 68
Thanked 2,701 Times in 2,586 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Crosstab query sorting problem

create another query based on the xtab query and apply the sorting.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 08-30-2018, 08:07 AM   #3
Wolfroolz
Newly Registered User
 
Join Date: May 2015
Posts: 32
Thanks: 22
Thanked 0 Times in 0 Posts
Wolfroolz is on a distinguished road
Re: Crosstab query sorting problem

Can you offer some examples? Not really sure what you mean. I am trying to sort the order of how the columns come up in the crosstab query report

Now it reads:
WE Date, Item1, Item2, Item3....etc
I want it to be:
WEDate, Item3, Item1, Item5...etc

Which would be based on the sort order field. I don't know how the query sort would change the column order.

Wolfroolz is offline   Reply With Quote
Old 08-30-2018, 12:58 PM   #4
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,785
Thanks: 34
Thanked 538 Times in 511 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Crosstab query sorting problem

Quote:
Specify column headings
Since the column headings are derived from a field, you only get fields relevant to the data. So, if your criteria limits the query to a period when Nancy Davolio made no sales, her field will not be displayed. If your goal is to make a report from the crosstab, the report will give errors if the field named "Davolio, Nancy" just disappears.

To solve this, enter all the valid column headings into the Column Headings property of the crosstab query. Steps:

In query design view, show the Properties box (View menu.)
Locate the Column Headings property. (If you don't see it, you are looking at the properties of a field instead of the properties of the query.)
Type in all the possible values, separated by commas. Delimit text values with quotes, or date values with #.
For the query above, set the Column Headings property like this (on one line):

"Buchanan, Steven", "Callahan, Laura", "Davolio, Nancy", "Dodsworth, Anne", "Fuller, Andrew", "King, Robert", "Leverling, Janet", "Peacock, Margaret", "Suyama, Michael"
Side effects of using column headings:

Any values you do not list are excluded from the query.
The fields will appear in the order you specify, e.g. "Jan", "Feb", "Mar", ...
Where a report has a complex crosstab query as its Record Source, specifying the column headings can speed up the design of the report enormously. If you do not specify the column headings, Access is unable to determine the fields that will be available to the report without running the entire query. But if you specify the Column Headings, it can read the field names without running the query.

An alternative approach is to alias the fields so the names don't change. Duane Hookom has an example of dynamic monthly crosstab reports.

Multiple sets of values
http://allenbrowne.com/ser-67.html
MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
Wolfroolz (08-31-2018)
Old 08-30-2018, 11:29 PM   #5
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,356
Thanks: 112
Thanked 2,843 Times in 2,593 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Crosstab query sorting problem

The quote from Allen Browne in the last post by MajP mentioned dynamic crosstab reports but without an explanation.
These do the opposite of fixed headers by allowing headings to be modified depending on the data.
This approach is very powerful and easy to do once you've seen the method in use.

I've posted several examples of these here.
For example https://www.access-programmers.co.uk...80&postcount=1
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 08-31-2018, 03:56 AM   #6
Wolfroolz
Newly Registered User
 
Join Date: May 2015
Posts: 32
Thanks: 22
Thanked 0 Times in 0 Posts
Wolfroolz is on a distinguished road
Re: Crosstab query sorting problem

Quote:
Originally Posted by MajP View Post
Thanks for this MajP. I think I am a little closer? But I still can't get there. If I just manually enter the headings then I lose the dynamic aspect of this. I want to allow the user to add/change types as needed, and they are not IT people, and they wont have anyone to support this and change the headings. As well, I don't know which class type they will select and there should only be headings for that class type.

However I was able to create a string based on the user selection that has the correct headings needed. I just can't figure out how to use it in the query. I tried putting it in a textbox on the form, and referencing that, but access just uses the reference as a column heading. I tried putting it into a global function and calling the function in sql, but I keep getting an error "Missing ), ], or Item in query expression"

Sql:
PARAMETERS [Forms]![ReportSelector]![cmbType] Text ( 255 ), [Forms]![ReportSelector]![tStart] DateTime, [Forms]![ReportSelector]![tEnd] DateTime;TRANSFORM Sum(qCust_Sched.Quantity) AS SumOfQuantitySELECT qCust_Sched.CUST_ID, qCust_Sched.GROUP_DESC, qCust_Sched.CONTACT, qCust_Sched.PROJECT_TASK, qCust_Sched.LOCATION, qCust_Sched.TEL_NUMBER, qCust_Sched.SECT_CODE, qCust_Sched.WeekEndDate, Sum(qCust_Sched.Quantity) AS [Total Of Quantity]FROM qCust_SchedGROUP BY qCust_Sched.CUST_ID, qCust_Sched.GROUP_DESC, qCust_Sched.CONTACT, qCust_Sched.PROJECT_TASK, qCust_Sched.LOCATION, qCust_Sched.TEL_NUMBER, qCust_Sched.SECT_CODE, qCust_Sched.WeekEndDatePIVOT qCust_Sched.Item_Type In (TypeSortOrder());

Code to create string:
Dim sortstring As String
Dim rs As DAO.Recordset
Dim db As Database
Dim strSQL As String Set db = CurrentDb
strSQL = "SELECT Item FROM TypeSortOrder WHERE Type = '" & Me.cmbType & "'"
Set rs = db.OpenRecordset(strSQL)
intX = 0
If rs.RecordCount > 0 Then Do While Not rs.EOF
sortstring = sortstring & "'" & rs!Item & "'," rs.MoveNext
Loop
End If
Me.sort = Left(sortstring, Len(sortstring) - 1)

Example of string output is: 'LH1S','LH1C','LH112S','LH112C','LH36','LH54'

On the command button that opens the report
StringSO = Me.sort

In seperate module
Global StringSO As String
Public Function TypeSortOrder() As String
TypeSortOrder = StringSO
End Function

Last edited by Wolfroolz; 08-31-2018 at 04:02 AM.
Wolfroolz is offline   Reply With Quote
Old 08-31-2018, 04:40 AM   #7
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,785
Thanks: 34
Thanked 538 Times in 511 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Crosstab query sorting problem

I think your output should be
[LH1S],[LH1C],...[LH54]
They are not strings but now column names.


Last edited by MajP; 08-31-2018 at 04:56 AM.
MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
Wolfroolz (08-31-2018)
Old 08-31-2018, 04:42 AM   #8
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,785
Thanks: 34
Thanked 538 Times in 511 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Crosstab query sorting problem

Examples
https://codingsight.com/understandin...erator-in-sql/
https://blogs.msdn.microsoft.com/spi...simple-sample/
MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
Wolfroolz (09-05-2018)
Old 08-31-2018, 05:59 AM   #9
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,396
Thanks: 68
Thanked 2,701 Times in 2,586 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Crosstab query sorting problem

can u upload a sample db.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
Wolfroolz (08-31-2018)
Old 08-31-2018, 06:12 AM   #10
Wolfroolz
Newly Registered User
 
Join Date: May 2015
Posts: 32
Thanks: 22
Thanked 0 Times in 0 Posts
Wolfroolz is on a distinguished road
Re: Crosstab query sorting problem

Using the examples, I noticed that they added a () as part of the pivot statement. I added that and it no longer gives me that error. Now however when I run the query it is acting like the function is blank, even though when I check the variable it is showing the correct value. I will try to submit a sample db.
Wolfroolz is offline   Reply With Quote
Old 08-31-2018, 06:53 AM   #11
Wolfroolz
Newly Registered User
 
Join Date: May 2015
Posts: 32
Thanks: 22
Thanked 0 Times in 0 Posts
Wolfroolz is on a distinguished road
Re: Crosstab query sorting problem

Here is a sample with fake data, all entries are for date 7/8/18. If you remove the in statement from the query everything works great, its just all in the wrong order.

BTW I tried it with both '' and [] and didn't seem to make any difference.

Appreciate everyone's help on this. Can't believe how complicated this report is getting. It seemed so simple when I thought it up, lol.
Attached Files
File Type: accdb DatabaseTest - Sample.accdb (908.0 KB, 10 views)
Wolfroolz is offline   Reply With Quote
Old 08-31-2018, 10:13 AM   #12
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,785
Thanks: 34
Thanked 538 Times in 511 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Crosstab query sorting problem

I could only make this work in code, but appears to work. Put this in your after update
Code:
Private Sub UpdateCrosstab()
  Dim qdf As QueryDef
  Dim db As Database
  Set db = CurrentDb
  Dim strSql As String
  Dim sqlStart As String
  Dim sqlEnd As String
  Dim sqlType
  sqlStart = SQL_Date(Me.tStart)
  sqlEnd = SQL_Date(Me.tEnd)
  sqlType = SQL_Text(Me.cmbType)
  'Update the Select query
  Set qdf = db.QueryDefs("qCust_Sched")
  strSql = "SELECT Cust_ID.CONTACT, Cust_ID.SECT_CODE, Cust_ID.CUST_ID, Cust_ID.GROUP_DESC, Cust_ID.PROJECT_TASK, Cust_ID.LEGACY_ACCT, Cust_ID.TEL_NUMBER, "
  strSql = strSql & "CUST_ID.LOCATION , CUST_ID.ORG, Schedule.WeekEndDate, Schedule.Item_Type, Schedule.Quantity, Items.Description, Types.Type, Items.Sort_Order "
  strSql = strSql & " FROM (Types INNER JOIN Items ON Types.Type = Items.Type) INNER JOIN (Cust_ID INNER JOIN Schedule ON Cust_ID.[CUST_ID] = Schedule.[Cust_ID]) "
  strSql = strSql & "ON Items.ITEM = Schedule.Item_Type WHERE Schedule.WeekEndDate Between " & sqlStart & " And " & sqlEnd & " And Schedule.WeekEndDate Between "
  strSql = strSql & sqlStart & " And " & sqlEnd & " AND Types.Type = " & sqlType
  qdf.SQL = strSql
  Debug.Print strSql
  'Update the XTab
  Set qdf = db.QueryDefs("qCust_Sched_Crosstab")
  strSql = "TRANSFORM Sum(qCust_Sched.Quantity) AS SumOfQuantity SELECT qCust_Sched.CUST_ID, qCust_Sched.GROUP_DESC, qCust_Sched.CONTACT, qCust_Sched.PROJECT_TASK, "
  strSql = strSql & "qCust_Sched.LOCATION, qCust_Sched.TEL_NUMBER, qCust_Sched.SECT_CODE, qCust_Sched.WeekEndDate, Sum(qCust_Sched.Quantity) AS [Total Of Quantity] "
  strSql = strSql & "FROM qCust_Sched GROUP BY qCust_Sched.CUST_ID, qCust_Sched.GROUP_DESC, qCust_Sched.CONTACT, qCust_Sched.PROJECT_TASK, qCust_Sched.LOCATION, "
  strSql = strSql & "qCust_Sched.TEL_NUMBER, qCust_Sched.SECT_CODE, qCust_Sched.WeekEndDate PIVOT qCust_Sched.Item_Type IN (" & TypeSortOrder & ")"
  qdf.SQL = strSql
  
  'I put a subform on the page to see the results
  'Me.subXtab.SourceObject = "Query.qCust_Sched_Crosstab"
End Sub
Public Function SQL_Date(ByVal varDate As Variant) As String
     If IsDate(varDate) Then
        If DateValue(varDate) = varDate Then
            SQL_Date = Format$(varDate, "\#mm\/dd\/yyyy\#")
        Else
            SQL_Date = Format$(varDate, "\#mm\/dd\/yyyy hh\:nn\:ss\#")
        End If
    Else
      SQL_Date = "NULL"
    End If
End Function
Public Function SQL_Text(ByVal varItem As Variant) As String
  If Not IsNull(varItem) Then
    varItem = Replace(varItem, "'", "''")
    SQL_Text = "'" & varItem & "'"
  Else
    SQL_Text = "Null"
  End If
End Function
MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
Wolfroolz (09-05-2018)
Old 08-31-2018, 10:46 AM   #13
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,356
Thanks: 112
Thanked 2,843 Times in 2,593 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Crosstab query sorting problem

You certainly over complicated this!

I've made a few changes to the query qCust_Sched

a) Fixed the date range criteria - you had added everything twice
b) Formatted the date fields as mm/dd/yyyy in the crirteria to allow the sSQL to work
c) Added the field Sort_Order from the Items table which is already used in the query

Now on the crosstab I've replaced the unnecessary 'IN' statement and replaced it with Sort_Order (Ascending)

The report now works correctly as far as I can tell but do check for yourself
The above solution involves no code changes
Attached Files
File Type: zip DatabaseTest - Sample v2 - CR.zip (85.0 KB, 4 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Wolfroolz (09-05-2018)
Old 08-31-2018, 11:47 AM   #14
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,785
Thanks: 34
Thanked 538 Times in 511 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Crosstab query sorting problem

But then you do not get any column headers on the sort order number as a column header.
For Hardrubber 2 I get
Code:
CONN	HOODSM	HOODLG	STIRRUP	FCC
5	8	4	7	8
5	5	87	5	58
9	8	2	8	2

You get
Code:
1	2	3	4	5
5	8	4	7	8
5	5	87	5	58
9	8	2	8	2
MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
Wolfroolz (09-05-2018)
Old 08-31-2018, 12:38 PM   #15
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,356
Thanks: 112
Thanked 2,843 Times in 2,593 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Crosstab query sorting problem

Ah yes - didn't notice that! How about this instead?



NOTE: I altered the date format to mm/dd/yyyy but the OP can change that back if preferred

Modified crosstab query:
Code:
PARAMETERS [Forms]![ReportSelector]![cmbType] Text ( 255 ), [Forms]![ReportSelector]![tStart] DateTime, [Forms]![ReportSelector]![tEnd] DateTime;
TRANSFORM Sum(qCust_Sched.Quantity) AS SumOfQuantity
SELECT qCust_Sched.CUST_ID, qCust_Sched.GROUP_DESC, qCust_Sched.CONTACT, qCust_Sched.PROJECT_TASK, qCust_Sched.LOCATION, qCust_Sched.TEL_NUMBER, qCust_Sched.SECT_CODE, qCust_Sched.WeekEndDate, Sum(qCust_Sched.Quantity) AS [Total Of Quantity]
FROM qCust_Sched
GROUP BY qCust_Sched.CUST_ID, qCust_Sched.GROUP_DESC, qCust_Sched.CONTACT, qCust_Sched.PROJECT_TASK, qCust_Sched.LOCATION, qCust_Sched.TEL_NUMBER, qCust_Sched.SECT_CODE, qCust_Sched.WeekEndDate
PIVOT [Sort_Order] & "_" & [Item_Type];
So this gives headers like 1_CONN, 2_HOODSM etc to ensure sorting is in the desired order
This means we need to modify one line in report GroupHeader0_Format procedure to remove the leading strings 1_, 2_ etc
:
Code:
Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
   Dim intX As Integer
   Dim i As Integer
    
   i = 1
   '  Put column headings into text boxes in page header.
   For intX = 10 To intColumnCount
      Me("Head" + Format(i)) = Mid(rstReport(intX - 1).Name, 3)
      Me("Head" + Format(i)).GridlineStyleRight = 1
      If intColumnCount < 22 Then
        Me("Head" + Format(i)).Width = 0.7 * 1440
        Else
            If Len(Me("Head" + Format(i))) > 5 Then
             Me("Head" + Format(i)).Width = Len(Me("Head" + Format(i))) * 150
            End If
        Me("Head" + Format(i)).FontSize = 10
        Me.Date.FontSize = 10
      End If
      i = i + 1
   Next intX

   '  Make next available text box Totals heading.
  ' Me("Head" + Format(intColumnCount - 8)) = "Totals"

   '  Hide unused text boxes in page header.
   For intX = (intColumnCount + 2) To conTotalColumns
      Me("Head" + Format(i)).Visible = False
   Next intX
End Sub
Hopefully it is now correct

EDIT: I have used this approach many times in the past. For example a student grades grid where the colour formatting depends not on the grade achieved but the residual grade i.e. the difference between the actual grade achieved & the target grade set earlier in the course. The actual grade is displayed but not the residual which controls the formatting.
The screenshot is low resolution but hopefully the idea is clear

Attached Images
File Type: png Capture.PNG (43.9 KB, 76 views)
File Type: jpg Exam6StudentResidualGrid.jpg (61.9 KB, 64 views)
Attached Files
File Type: zip DatabaseTest - Sample v3 - CR.zip (83.6 KB, 8 views)

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 08-31-2018 at 03:55 PM.
isladogs is offline   Reply With Quote
The Following 2 Users Say Thank You to isladogs For This Useful Post:
MajP (08-31-2018), Wolfroolz (09-05-2018)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Date Columns in Crosstab Query PaulA Queries 10 03-26-2009 09:57 AM
Sorting Dates in crosstab query PaulJR Queries 3 01-19-2009 09:34 AM
Sorting Crosstab query tkaplan Queries 4 07-12-2005 10:36 AM
Sorting a Crosstab query by the Values Carly Queries 0 02-15-2005 06:20 AM
Sorting Rows in a Crosstab Query CCIDBMNG Queries 11 09-05-2002 07:30 PM




All times are GMT -8. The time now is 06:53 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World