If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
report info not in order
I am have a problem with my report. the order that i
imputed the information in the cells is not the order that the information is being displayed in the report. ifact, the information does not seem to be in any order. it is the days of the week. I imputed from Sun. through Sat. but the report gives me random days and its not even alphabetical. what do I do? |
#2
|
|||
|
|||
report info not in order
On Tue, 10 Aug 2004 12:26:28 -0700, wrote:
I am have a problem with my report. the order that i imputed the information in the cells is not the order that the information is being displayed in the report. ifact, the information does not seem to be in any order. it is the days of the week. I imputed from Sun. through Sat. but the report gives me random days and its not even alphabetical. what do I do? To sort records in a report, you must use the Report's Sorting and Grouping dialog. In Report Design View, click on View + Sorting and Grouping. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#3
|
|||
|
|||
report info not in order
wrote:
I am have a problem with my report. the order that i imputed the information in the cells is not the order that the information is being displayed in the report. ifact, the information does not seem to be in any order. it is the days of the week. I imputed from Sun. through Sat. but the report gives me random days and its not even alphabetical. what do I do? Note 1. The records in a relational database table are unordered. You must have a field in the table that can be used to sort the records in the way that you want. Note 2. In all but simple cases, the sorting of a report needs to be specified in the report's Sorting and Grouping window (View menu). Incorporate those requirements into your thinking and, is you need more help, post back with more details about the type and values of the field you want to sort and how you specified the sort order. -- Marsh MVP [MS Access] |
#4
|
|||
|
|||
report info not in order
the day ofthe week were specificly entered the their
natural order in the day table. next I checked the query and they appear in instead of Sun through Sat. they run Mon through Sun. the report runs off of the query however the days just don't make sence. they are in no particular order. in the query is there any way to specify that I wan't the days to start and end were I want them to not the computer making up the order and not excluding any days? -----Original Message----- wrote: I am have a problem with my report. the order that i imputed the information in the cells is not the order that the information is being displayed in the report. ifact, the information does not seem to be in any order. it is the days of the week. I imputed from Sun. through Sat. but the report gives me random days and its not even alphabetical. what do I do? Note 1. The records in a relational database table are unordered. You must have a field in the table that can be used to sort the records in the way that you want. Note 2. In all but simple cases, the sorting of a report needs to be specified in the report's Sorting and Grouping window (View menu). Incorporate those requirements into your thinking and, is you need more help, post back with more details about the type and values of the field you want to sort and how you specified the sort order. -- Marsh MVP [MS Access] . |
#5
|
|||
|
|||
report info not in order
wrote:
the day ofthe week were specificly entered the their natural order in the day table. next I checked the query and they appear in instead of Sun through Sat. they run Mon through Sun. the report runs off of the query however the days just don't make sence. they are in no particular order. in the query is there any way to specify that I wan't the days to start and end were I want them to not the computer making up the order and not excluding any days? There is no such thing as a natural order in a table. Almost always, sorting the query for a report is a waste of time. What type of field (in the table) is the day of the week? Date/Time? Integer? or Text? What are some sample values for day of the week? -- Marsh MVP [MS Access] |
#6
|
|||
|
|||
report info not in order
what i ment by natural order was the days of the week.
I created a teble called days and 1 field in that table containing the days of the week each with its own ID#. In conference table days is a look-table with a drop down list of the days. S M T W Th F S is the order in which I entered the info. In the conference query day is one of the table which I used. In design view you can see the tables years, season, destination, hotel, day , blocked and so on. In the criteria row, I indicated 1995 for years, spring for season, and so on. the days I did only indecated a criteria when I only wnated a day to appear in the report. this is my problem: when I let all days appear, thay are not in the order in which I entered them in the table. when I am creating the report using the wizard I have a choice to add another grouping (days) or go to the screen and and sort. If I sort It will come out in alphabetical order and I don't want that. If I group before that I can't sort the days table and the finished product comes out all messed up. the days are in no particular order as per below: Friday 7 2 0 0% 0% Monday 75 24 20 27% 83% Saturday 0 0 0 Sunday 20 1 1 5% 100% Thursday 39 39 23 59% 59% Tuesday 95 69 47 49% 68% Wednesday this is not how the information was entered. WHAT DO I DO? -----Original Message----- wrote: the day ofthe week were specificly entered the their natural order in the day table. next I checked the query and they appear in instead of Sun through Sat. they run Mon through Sun. the report runs off of the query however the days just don't make sence. they are in no particular order. in the query is there any way to specify that I wan't the days to start and end were I want them to not the computer making up the order and not excluding any days? There is no such thing as a natural order in a table. Almost always, sorting the query for a report is a waste of time. What type of field (in the table) is the day of the week? Date/Time? Integer? or Text? What are some sample values for day of the week? -- Marsh MVP [MS Access] . |
#7
|
|||
|
|||
report info not in order
As Marshall already pointed out reports do their own
sorting/grouping. So, in order to sort your table where you have given the days criptic names, you must add a column an for instanc ename it DaySeq (for day sequence), here you would mark the days' sequence like 1, 2, 3 etc, than you can sort the report base on this column and you do not need to include it on the face of the report. Hope this helps. Fons -----Original Message----- what i ment by natural order was the days of the week. I created a teble called days and 1 field in that table containing the days of the week each with its own ID#. In conference table days is a look-table with a drop down list of the days. S M T W Th F S is the order in which I entered the info. In the conference query day is one of the table which I used. In design view you can see the tables years, season, destination, hotel, day , blocked and so on. In the criteria row, I indicated 1995 for years, spring for season, and so on. the days I did only indecated a criteria when I only wnated a day to appear in the report. this is my problem: when I let all days appear, thay are not in the order in which I entered them in the table. when I am creating the report using the wizard I have a choice to add another grouping (days) or go to the screen and and sort. If I sort It will come out in alphabetical order and I don't want that. If I group before that I can't sort the days table and the finished product comes out all messed up. the days are in no particular order as per below: Friday 7 2 0 0% 0% Monday 75 24 20 27% 83% Saturday 0 0 0 Sunday 20 1 1 5% 100% Thursday 39 39 23 59% 59% Tuesday 95 69 47 49% 68% Wednesday this is not how the information was entered. WHAT DO I DO? -----Original Message----- wrote: the day ofthe week were specificly entered the their natural order in the day table. next I checked the query and they appear in instead of Sun through Sat. they run Mon through Sun. the report runs off of the query however the days just don't make sence. they are in no particular order. in the query is there any way to specify that I wan't the days to start and end were I want them to not the computer making up the order and not excluding any days? There is no such thing as a natural order in a table. Almost always, sorting the query for a report is a waste of time. What type of field (in the table) is the day of the week? Date/Time? Integer? or Text? What are some sample values for day of the week? -- Marsh MVP [MS Access] . . |
#8
|
|||
|
|||
report info not in order
helps a lot thanks
-----Original Message----- As Marshall already pointed out reports do their own sorting/grouping. So, in order to sort your table where you have given the days criptic names, you must add a column an for instanc ename it DaySeq (for day sequence), here you would mark the days' sequence like 1, 2, 3 etc, than you can sort the report base on this column and you do not need to include it on the face of the report. Hope this helps. Fons -----Original Message----- what i ment by natural order was the days of the week. I created a teble called days and 1 field in that table containing the days of the week each with its own ID#. In conference table days is a look-table with a drop down list of the days. S M T W Th F S is the order in which I entered the info. In the conference query day is one of the table which I used. In design view you can see the tables years, season, destination, hotel, day , blocked and so on. In the criteria row, I indicated 1995 for years, spring for season, and so on. the days I did only indecated a criteria when I only wnated a day to appear in the report. this is my problem: when I let all days appear, thay are not in the order in which I entered them in the table. when I am creating the report using the wizard I have a choice to add another grouping (days) or go to the screen and and sort. If I sort It will come out in alphabetical order and I don't want that. If I group before that I can't sort the days table and the finished product comes out all messed up. the days are in no particular order as per below: Friday 7 2 0 0% 0% Monday 75 24 20 27% 83% Saturday 0 0 0 Sunday 20 1 1 5% 100% Thursday 39 39 23 59% 59% Tuesday 95 69 47 49% 68% Wednesday this is not how the information was entered. WHAT DO I DO? -----Original Message----- wrote: the day ofthe week were specificly entered the their natural order in the day table. next I checked the query and they appear in instead of Sun through Sat. they run Mon through Sun. the report runs off of the query however the days just don't make sence. they are in no particular order. in the query is there any way to specify that I wan't the days to start and end were I want them to not the computer making up the order and not excluding any days? There is no such thing as a natural order in a table. Almost always, sorting the query for a report is a waste of time. What type of field (in the table) is the day of the week? Date/Time? Integer? or Text? What are some sample values for day of the week? -- Marsh MVP [MS Access] . . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Using prompt info for a title to a report | Donna | Setting Up & Running Reports | 1 | June 8th, 2004 06:39 AM |
Help with report...need to list if any info was missing from application. | Jacqueline | Setting Up & Running Reports | 2 | June 3rd, 2004 01:38 PM |
Change sort order of report | Setting Up & Running Reports | 2 | May 26th, 2004 06:20 AM | |
Purchase order | Ross | Worksheet Functions | 1 | October 20th, 2003 11:30 AM |