Hi...
I have created MS Access database for stores management and every thing is okay, there is purchase table ,receive table ,transfer table and damage table .
each one contain two table, now my problem is in the purchase table
let's take a look please - first table
-
sno inv_no date supplier
- second table
-
sno code details qty price discount tot
__________________
the first_table.sno is connected to the second_table.sno
one to many relationship
_______________________
and the database is connected to vb
I have created report ,and what is happening is.. - first table
-
sno inv_no date supplier
-
1 0000 13-12-16 bla bla bla
- second table
-
sno code details qty price discount tot
-
1 01 hammer 4 10 0 40
-
2 02 screw 1 10 0 10
-
3 03 bottle 2 5 0 10
now when I print report it will reverse automatically, like this... - sno code details qty price discount tot
-
3 03 bottle 2 5 0 10
-
2 02 screw 1 10 0 10
-
1 01 hammer 4 10 0 40
Please help me...
thank you in advance...
15 1604
In the record source for the report, have it order by sno.
thank you for your reply ...
order by sno, did nothing.
Can't see your image. It would help if you post your record source code.
This is for filling table as you know - Me.Pu_it_QueryTableAdapter.Fill(Me.DbDDDataSet.pu_it_Query)
And this is inside table adapter - SELECT Inv_no, Pu_date
-
, P_no_pu, P_name
-
, code, Item_details
-
, price, qty
-
, dic, Su_name
-
, Sup_noT, U_name
-
, Total, name
-
, [For], Grandtot
-
, totDes, Purchase_no
-
FROM [pu_it Query]
-
ORDER BY Purchase_no
__________________________
and please don't forget that I have other tables with the same manner :), and they are work fine
thank you for your patient..
I should mention that ,in purchase table which user should use, is from tables in ms access and the report from query in same database
...
zmbd 5,501
Expert Mod 4TB
for the momement place the field [Purchase_no] so that is visible in the records. Compare the order of the [Purchase_no] values to what you want.
I don't see this sno field that you referred to in your orignal post.
Sorry rabbit I just used easy name instead of Purchase_no..
thank you zmbd you mean putting the Purchase_no in the sub Table
then order it.... I want it to be ordered to the user table order
:( is that possible...
and again don't forget I got other tables and it's just work fine
Thank you ...
zmbd 5,501
Expert Mod 4TB
xzorxx :
None of the images you posted are available to myself and I suspect most of the experts here as we are normally at work PCs where IT policy will block image and file storage sites.
You were told about this by Rabbit in Post#4 and via the moderator's edit tag in your previous post.
The other thing, your post becomes worthless to others if the images in the third party site are ever deleted, the site goes down for any reason, or if they are also in the same boat where their IT dept blocks image and file storage sites.
Will you please, take the time to actually describe what you did?
Yeah sure, sorry about that
I fixed the database query to add serial no to the sub table then try to order it but nothing happened ..!!
then i was thinking about report expression could I reverse the data from it..?
that's it and sorry again
also you can delete the hole thing if it's not okay to your site sorry
zmbd 5,501
Expert Mod 4TB
I fixed the database query to add serial no to the sub table then try to order it but nothing happened ..!!
Post the actual SQL
then i was thinking about report expression could I reverse the data from it..?
As you have this in the VB section and not Access/VBA, I'm not sure how to direct you here... normally in the Access program you can alter sort orders in the details section by altering the group/sort/total property
also you can delete the hole thing if it's not okay to your site sorry
Still would like to have the details instead of the pictures, if you would? We can replace the pics with the details.
Sure replace it please...
This is the SQL - SELECT Purchase_T.Purchase_no, Purchase_T.Inv_no, Purchase_T.Pu_date, Purchase_T.P_no_pu, Projects_T.P_name, Purchaser_T.name, Purchase_T.Sup_noT, Suppliers_T.Su_name, Purchase_T.For, pu_it.pu_no, pu_it.code, Item_T.Item_details, Units_T.U_name, pu_it.qty, pu_it.price, pu_it.dic, [qty]*[price]-[dic] AS Total, Purchase_T.totDes, [Total]-[totDes] AS Grandtot
-
FROM Units_T INNER JOIN (Suppliers_T INNER JOIN (Purchaser_T INNER JOIN ((Projects_T INNER JOIN Purchase_T ON Projects_T.P_no=Purchase_T.P_no_pu) INNER JOIN (Item_T INNER JOIN pu_it ON Item_T.Codeit=pu_it.code) ON Purchase_T.Purchase_no=pu_it.pu_no) ON Purchaser_T.Purchaser_no=Purchase_T.Purchaser_noT) ON Suppliers_T.Sup_no=Purchase_T.Sup_noT) ON Units_T.U_no=Item_T.U_no
-
ORDER BY Purchase_T.Purchase_no;
How come the most recent query is so different from the first query you posted in #5?
I am truly sorry mr.Rabbit the first SQL code from vb
second from ms access db..!!
good news is Just minute ago I have solve the problem I recreated the Purchase Query from 0 again ,and now it's work fine..!!
thank you very much
Not sure what went wrong but I'm glad you got your problem fixed.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Monica Ferrero |
last post by:
Hi!
I'm not sure if this is the most adequate mySQL list for this post. If not,
please indicat me which one I should use...
I'm using Tomcat 4.1.24 with Apache 2 and MySQL 4.0.13. I have the...
|
by: Lefteris |
last post by:
Hi,
I am trying to write a simple application in javascript that
automatically fills the fields of a form in a page at another domain.
I display the foreign domain page on a frame and have the...
|
by: Marcus |
last post by:
(Appologies if this group isn't the best place for this post)
Is it possible to use DAO 3.6 to access binary data (varbinary(max)) in
Sql Server 2005? I have images and sound in a Sql 2005 DB...
|
by: remote |
last post by:
when i try to access my data access page remotely with i can't get my data. Why this happens?
|
by: Dilruba |
last post by:
I want retrieve data from Ms Access 2000 database by using ASP and data type memo and after that i want e-mail that data automatically
|
by: Dilruba |
last post by:
I have tried to take Memo (Access 2000) data type in a Dim variable.
After that i have send it via e-mail text. But it is not sending the vaule.
Here is the code that i have used:
<% Dim msgDb...
|
by: nithya jayaraman |
last post by:
hi
now i am using vb with MS Access ... but i have some information in excel wook sheet , so access that data and store to data grid then find out the average of the sheet 1 and sheet 2 and...
|
by: JFKJr |
last post by:
Hi! I have exported an access table data into an excel file using the following code. However, the code exported all the data to the excel sheet starting from 'A' cell (first column). But I want to...
|
by: Cirene |
last post by:
I know that there are several ways to access/query data. (Stored procs,
direct SQL statements, etc...)
Typically I write a simple Stored Procedure, then access it from my webform
like this...
...
|
by: mb60 |
last post by:
I have two columns in my access table -FIELD1 and FIELD2. Field1 has the names of some animals.
If I enter a name BIRD in Field 1, automatically a prescribed number , for example '2' should be...
|
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: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |