Sorting

[k11ngy]

I have a report based on Parameter query to select a delivery round

The 2 fields in question in the report are: Address = House no and Address
= Street name. I need to sort the Street name A-Z and House number as Lowest
number to Highest. I have them set as text as some house nos are for example
110B or 10A and so on

Can anyone help?

Thanks

Steve

 

[John Spencer]

In the report use the Sorting and Grouping dialog (View: Sorting and
Sort by the Street name field in Ascending order.
Then Sort by
=Val([House number] & "")
You might want a third sort level of
[House Number]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[k11ngy]

Hi John

Not having much luck here, probably me as novice. I am using 2007 if that
makes any difference? In report design view I have added sort for street
name in A-Z =address 1

In the field for House number I right clicked and chose "Build event" ?? and
wrote in the =Val([address 2] & "")

Probably me doing it wrong?

Thanks for help-appreciated

Steve

In the report use the Sorting and Grouping dialog (View: Sorting and
Sort by the Street name field in Ascending order.
Then Sort by
=Val([House number] & "")
You might want a third sort level of
[House Number]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

I have a report based on Parameter query to select a delivery round

The 2 fields in question in the report are: Address = House no and Address
= Street name. I need to sort the Street name A-Z and House number as Lowest
number to Highest. I have them set as text as some house nos are for example
110B or 10A and so on

Can anyone help?

Thanks

Steve

 

[John Spencer]

Sorry, I cannot help you. I don't do 2007 due to the fact that none of
my clients have switched over to 2007.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Hi John

Not having much luck here, probably me as novice. I am using 2007 if that
makes any difference? In report design view I have added sort for street
name in A-Z =address 1

In the field for House number I right clicked and chose "Build event" ?? and
wrote in the =Val([address 2] & "")

Probably me doing it wrong?

Thanks for help-appreciated

Steve

In the report use the Sorting and Grouping dialog (View: Sorting and
Sort by the Street name field in Ascending order.
Then Sort by
=Val([House number] & "")
You might want a third sort level of
[House Number]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

I have a report based on Parameter query to select a delivery round

The 2 fields in question in the report are: Address = House no and Address
= Street name. I need to sort the Street name A-Z and House number as Lowest
number to Highest. I have them set as text as some house nos are for example
110B or 10A and so on

Can anyone help?

Thanks

Steve

 

[k11ngy]

No Worries John, will keep at it

Thanks again for your help

Regards

Steve

Sorry, I cannot help you. I don't do 2007 due to the fact that none of
my clients have switched over to 2007.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Hi John

Not having much luck here, probably me as novice. I am using 2007 if that
makes any difference? In report design view I have added sort for street
name in A-Z =address 1

In the field for House number I right clicked and chose "Build event" ?? and
wrote in the =Val([address 2] & "")

Probably me doing it wrong?

Thanks for help-appreciated

Steve

In the report use the Sorting and Grouping dialog (View: Sorting and
Sort by the Street name field in Ascending order.
Then Sort by
=Val([House number] & "")
You might want a third sort level of
[House Number]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


k11ngy wrote:
I have a report based on Parameter query to select a delivery round

The 2 fields in question in the report are: Address = House no and Address
= Street name. I need to sort the Street name A-Z and House number as Lowest
number to Highest. I have them set as text as some house nos are for example
110B or 10A and so on

Can anyone help?

Thanks

Steve

 

[k11ngy]

Me again John

Gone back to Access 2003 now

Can I ask

I have 2 fields address 1 = Street Name and Address 2 = House number

These are in the Table/query and of course final report

I went into Report-design View and chose Grouping and sorting and I can of
course see both fields in the box

1. I left Address 1 as it was and aascending
2. Where it shows address 2, do I delete that and put in the expression as
below?

=Val([address 2] & "")

I have tried and all i get is paremeter popping up asking for "Address 1" ???

Thanks again

Steve

In the report use the Sorting and Grouping dialog (View: Sorting and
Sort by the Street name field in Ascending order.
Then Sort by
=Val([House number] & "")
You might want a third sort level of
[House Number]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

I have a report based on Parameter query to select a delivery round

The 2 fields in question in the report are: Address = House no and Address
= Street name. I need to sort the Street name A-Z and House number as Lowest
number to Highest. I have them set as text as some house nos are for example
110B or 10A and so on

Can anyone help?

Thanks

Steve

 

[John Spencer]

IF you get a parameter popping up asking for Address 1 then you either
don't have a field named Address 1 or you don't have that field in the
record source for the report or you have managed to misspell the field
name. Perhaps you have typed Address Space Space 1?

=Val([Address 2] & "") should work

If you are having troubles with Address 1, you need to make sure you
have surrounded it with square brackets also. Field names and table
names with spaces must be referred to using square brackets.

[Table Name with Space].[Field name with space]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Me again John

Gone back to Access 2003 now

Can I ask

I have 2 fields address 1 = Street Name and Address 2 = House number

These are in the Table/query and of course final report

I went into Report-design View and chose Grouping and sorting and I can of
course see both fields in the box

1. I left Address 1 as it was and aascending
2. Where it shows address 2, do I delete that and put in the expression as
below?

=Val([address 2] & "")

I have tried and all i get is paremeter popping up asking for "Address 1" ???

Thanks again

Steve

In the report use the Sorting and Grouping dialog (View: Sorting and
Sort by the Street name field in Ascending order.
Then Sort by
=Val([House number] & "")
You might want a third sort level of
[House Number]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

I have a report based on Parameter query to select a delivery round

The 2 fields in question in the report are: Address = House no and Address
= Street name. I need to sort the Street name A-Z and House number as Lowest
number to Highest. I have them set as text as some house nos are for example
110B or 10A and so on

Can anyone help?

Thanks

Steve

 

[k11ngy]

John, you are a star

The light bulb finally came on when you mentioned field names and spacing.
My address 2 is YES address2 No spacing and it works fine. Must have been
the morning after St Patricks day

Thanks so much for help John

Kind regards and enjoy weekend

Steve

IF you get a parameter popping up asking for Address 1 then you either
don't have a field named Address 1 or you don't have that field in the
record source for the report or you have managed to misspell the field
name. Perhaps you have typed Address Space Space 1?

=Val([Address 2] & "") should work

If you are having troubles with Address 1, you need to make sure you
have surrounded it with square brackets also. Field names and table
names with spaces must be referred to using square brackets.

[Table Name with Space].[Field name with space]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Me again John

Gone back to Access 2003 now

Can I ask

I have 2 fields address 1 = Street Name and Address 2 = House number

These are in the Table/query and of course final report

I went into Report-design View and chose Grouping and sorting and I can of
course see both fields in the box

1. I left Address 1 as it was and aascending
2. Where it shows address 2, do I delete that and put in the expression as
below?

=Val([address 2] & "")

I have tried and all i get is paremeter popping up asking for "Address 1" ???

Thanks again

Steve

In the report use the Sorting and Grouping dialog (View: Sorting and
Sort by the Street name field in Ascending order.
Then Sort by
=Val([House number] & "")
You might want a third sort level of
[House Number]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


k11ngy wrote:
I have a report based on Parameter query to select a delivery round

The 2 fields in question in the report are: Address = House no and Address
= Street name. I need to sort the Street name A-Z and House number as Lowest
number to Highest. I have them set as text as some house nos are for example
110B or 10A and so on

Can anyone help?

Thanks

Steve