Hello,
I encounter a problem that I cannot solve myself...
The problem is the following:
I make a table: several records: the first field is always a number,
the following field is always an address
When I make a query based on the numbers, the result (rapport) is
listed in the way it was entered in the table, it is not listed in the
way I enter it in the query.
But I need it to be shown in the order of the query.
I hope you understand my problem, if not, please leave a message so I
can explain it to you in a different way
Thank you very much for your help
Philippe 4 1434
Philippe wrote: Hello,
I encounter a problem that I cannot solve myself...
The problem is the following:
I make a table: several records: the first field is always a number, the following field is always an address
When I make a query based on the numbers, the result (rapport) is listed in the way it was entered in the table, it is not listed in the way I enter it in the query.
But I need it to be shown in the order of the query.
I hope you understand my problem, if not, please leave a message so I can explain it to you in a different way
Thank you very much for your help
Philippe
Are you sorting the query. Open up the query in design view. From the
menu select View/SQL. Do you see an ORDER BY in the SQL? If so, write
back and try to describe the problem with more detail. If you don't see
OrderBy, select View/Design and you'll see a row called Sort. Click on
that row for the fields you want sorted.
If the fields are in the order of ID, DateField, CountField but you want
to sort it by CountField, DateField you need to
1) switch the order or
2) drag down CountField and DateField...in the order you want sorted...,
click the Show checkbox off, and set the Sort row for the fields in Asc
or Desc order.
On 23 Jun 2004 08:54:50 -0700, p.******@jcp.be (Philippe) wrote: Hello,
I encounter a problem that I cannot solve myself...
The problem is the following:
I make a table: several records: the first field is always a number, the following field is always an address
When I make a query based on the numbers, the result (rapport) is listed in the way it was entered in the table, it is not listed in the way I enter it in the query.
But I need it to be shown in the order of the query.
I hope you understand my problem, if not, please leave a message so I can explain it to you in a different way
Thank you very much for your help
Philippe
This is a report? If so then use the reports sorting and grouping
feature to select the field you want to order by.
- Jim
If you want the report to look like the query, then base the report
off the query, not the table. Also, you shouldn't be entering things
in a query...forms are usually used for data entry...
good luck
"Jim Allensworth" <ji****@Notdatacentricsolutions.com> wrote in message news:<40*****************@news.west.earthlink.net> ... On 23 Jun 2004 08:54:50 -0700, p.******@jcp.be (Philippe) wrote:
Hello,
I encounter a problem that I cannot solve myself...
The problem is the following:
I make a table: several records: the first field is always a number, the following field is always an address
When I make a query based on the numbers, the result (rapport) is listed in the way it was entered in the table, it is not listed in the way I enter it in the query.
But I need it to be shown in the order of the query.
I hope you understand my problem, if not, please leave a message so I can explain it to you in a different way
Thank you very much for your help
Philippe This is a report? If so then use the reports sorting and grouping feature to select the field you want to order by.
- Jim
Huh? I assume you weren't responding to me.
As I mentioned, forget about how the query returns records and use the
reports Sorting and Grouping to provide the order.
I wonder where you got the idea about *entering* data - in forms,
queries or whatever.
- Jim
On 23 Jun 2004 17:34:16 -0700, va***@hotmail.com (Enterprise) wrote: If you want the report to look like the query, then base the report off the query, not the table. Also, you shouldn't be entering things in a query...forms are usually used for data entry...
good luck
"Jim Allensworth" <ji****@Notdatacentricsolutions.com> wrote in message news:<40*****************@news.west.earthlink.net> ... On 23 Jun 2004 08:54:50 -0700, p.******@jcp.be (Philippe) wrote:
>Hello, > >I encounter a problem that I cannot solve myself... > >The problem is the following: > > >I make a table: several records: the first field is always a number, >the following field is always an address > > >When I make a query based on the numbers, the result (rapport) is >listed in the way it was entered in the table, it is not listed in the >way I enter it in the query. > > >But I need it to be shown in the order of the query. > > >I hope you understand my problem, if not, please leave a message so I >can explain it to you in a different way > > >Thank you very much for your help > >Philippe This is a report? If so then use the reports sorting and grouping feature to select the field you want to order by.
- Jim This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Xenophobe |
last post by:
I have successfully converted the ASP code included in the following article
to PHP:
http://www.4guysfromrolla.com/webtech/040100-1.shtml
As described the high and low latitudes and longitudes...
|
by: Jeff Blee |
last post by:
I hope someone can help me get this graph outputing in proper order.
After help from Tom, I got a graph to display output from the previous
12 months and include the average of that output all in...
|
by: kaosyeti |
last post by:
i have a (hopefully) small problem. i have created a system where a user
enters customer information into a table through a form. this table has no
primary key. there are 9 fields on the form to...
|
by: elein |
last post by:
Yes, I vacuumed. Reproduced on both 7.3.2 and 7.5.
Brain dead java beans want order by clauses in views
that they use.
my view is:
select ....
from bigtable b left join lookuptable l
order...
|
by: mcollier |
last post by:
I have some VB6 code that calls a SELECT query in Microsoft Access.
When I run the query from access, the results appear in not particular
order. However, when I call the query from VB6, via ADO,...
|
by: Beowulf |
last post by:
I have the view below and if I use vwRouteReference as the rowsource
for a combo box in an MS Access form or run "SELECT * FROM
vwRouteReference" in SQL Query Analyzer, the rows don't come through...
|
by: beconrad |
last post by:
Hi all,
I am not sure if what I want to do is possible, and if it is I have not
been able to figure out how to do it. This is what I would like:
1. I have a data entry form with a field...
|
by: InnoCreate |
last post by:
Hi everyone.
I've recently written a classic asp website which uses an MS Access
datasource. I know this is less than an ideal data source as it has
limited functionality. I have a search form on...
|
by: EwanD |
last post by:
I am trying to read through and process an Access Query using VBA.
I have used the OpenRecordset method with parameters as below
OpenRecordset(sSourceRecordset, dbOpenDynaset)
Where...
|
by: altafur |
last post by:
hi,
i am using java with hibernate . i want to run a hibernate order by query thru java.
i have written the query in hibernate.hbm.xml file. the query is as follows:
query:
SELECT distinct...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |