Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-02-2019, 09:26 AM   #1
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 94
Thanks: 61
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Desired Grouping Field Not Available

Hello all,

I have a select query to return all data based on a checkbox, which works great.

The fields being returned are as follows: OrderID, Facility, Description, OrderDate, PurchNum, InvoiceDate, InvoiceNum

I am trying to make a report to group on the Facility, however whenever I run the Report Wizard, that option isn't available for grouping, nor if I make a report and try to do the grouping under the properties, its not listed their neither, any thoughts??

Edit: Forgot the OrderID column, which is set as the Identity field on the SQL Side
Attached Images
File Type: png Report Wizard.PNG (17.7 KB, 10 views)
File Type: png Properties.PNG (7.0 KB, 8 views)

NearImpossible is offline   Reply With Quote
Old 12-02-2019, 09:27 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,436
Thanks: 58
Thanked 1,411 Times in 1,392 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Desired Grouping Field Not Available

Hi. Can you post the SQL statement for your query? Is the missing field available for sorting?
__________________
Just my 2 cents...

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.
theDBguy is online now   Reply With Quote
Old 12-02-2019, 09:29 AM   #3
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 94
Thanks: 61
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Re: Desired Grouping Field Not Available

Quote:
Originally Posted by theDBguy View Post
Hi. Can you post the SQL statement for your query? Is it available for sorting?
Code:
SELECT *
FROM EquipmentOrders
WHERE EquipmentOrders.[Awaiting Payment]=1

NearImpossible is offline   Reply With Quote
Old 12-02-2019, 09:34 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,436
Thanks: 58
Thanked 1,411 Times in 1,392 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Desired Grouping Field Not Available

Quote:
Originally Posted by NearImpossible View Post
Code:
SELECT *
FROM EquipmentOrders
WHERE EquipmentOrders.[Awaiting Payment]=1
Hi. Thanks. Can you post a screenshot of the table EquipmentOrders in Design View? What is the Data Type for the Facility field?
__________________
Just my 2 cents...

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.
theDBguy is online now   Reply With Quote
Old 12-02-2019, 09:37 AM   #5
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 94
Thanks: 61
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Re: Desired Grouping Field Not Available

Quote:
Originally Posted by theDBguy View Post
Hi. Thanks. Can you post a screenshot of the table EquipmentOrders in Design View? What is the Data Type for the Facility field?
Please see attached, apparently its an issue with the nvarchar(Max) type as nvarchar(50) types show
Attached Images
File Type: png Table.PNG (9.6 KB, 8 views)
File Type: png Query Return.PNG (7.7 KB, 4 views)
NearImpossible is offline   Reply With Quote
Old 12-02-2019, 09:44 AM   #6
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,436
Thanks: 58
Thanked 1,411 Times in 1,392 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Desired Grouping Field Not Available

Quote:
Originally Posted by NearImpossible View Post
Please see attached, apparently its an issue with the nvarchar(Max) type as nvarchar(50) types show
Hi. That's correct. You can't group or sort on long text or memo fields. Sorry.
__________________
Just my 2 cents...

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.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
NearImpossible (12-02-2019)
Old 12-02-2019, 09:45 AM   #7
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 94
Thanks: 61
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Re: Desired Grouping Field Not Available

Quote:
Originally Posted by theDBguy View Post
Hi. That's correct. You can't group or sort on long text or memo fields. Sorry.
That's good to know, so what is the magic number of characters before its not longer group-able?

NearImpossible is offline   Reply With Quote
Old 12-02-2019, 09:46 AM   #8
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,436
Thanks: 58
Thanked 1,411 Times in 1,392 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Desired Grouping Field Not Available

Quote:
Originally Posted by NearImpossible View Post
That's good to know, so what is the magic number of characters before its not longer group-able?
255 chars (I think).

__________________
Just my 2 cents...

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.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
NearImpossible (12-02-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Display Desired Format in Field, Clears on Focus (Easy question, I hope) RogueJD Forms 2 12-27-2012 09:54 PM
Grouping subreport field to Main Report Field t_bard Reports 0 12-22-2011 08:41 AM
Bringing cursor to the desired field on opening Data Entry Form gear Forms 2 04-04-2007 01:52 AM
Bringing cursor to the desired field on opening Data Entry Form gear Forms 1 04-03-2007 03:34 AM
Getting Desired Field List djruni Reports 1 02-09-2006 01:35 AM




All times are GMT -8. The time now is 10:22 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