Hi ,

 I got an DB which is created by my colligue earlier now my boss told me to updated the DB. The Details are below..

 DB Name :Computer & Accessories Database Managment
 Discription :DB to Account Computer & it Accessories
 Table :Main table of Equipment name , make , Modle so no...
 Query :To get the data by Equipment name wise
 From :To enter the full data
 Report :1. Total Report & 2.Base on the Query.

 What was have observer is the data's have been update in the from once the equipment arrive to my office i.e. if printer arrive then it ill enterd so no...

 Now i want to add the some data (i.e. new arriavls) and i want to change data (i.e. shift for computer from one room to another).If i did any correctoin in the data is doesn't reflect in the report
i.e. while iam taking the report in equipment name wise the is sl.No. is colapesing bcs of this continous updation & altertion

 what i did was i had given sorting & grouping option in the report but no result..

 what i want what the serial no may be data store but when iam going to take the equipment report it should shows continous ... 1,2,3,4,5,6, like this

 * Note iam sorting the datas Room number which iam entering in the from....

Pls help i not to understand pls rpl..
thanks in advance...

 Certain possibilities....

1. Make sure if the data is storing into the correct table once you updated thru form. (I doubt..). check the VBA codes that written behind the save command button (Incase SAVE button is placed on the form)

2. Check the form's data tab in the property if it is set appropriate. (All addition = yes/no etc..) This may be one of the reason.

3. Check the criteria in query that is set with report.


.....


Displaying of records in ascending or descending manner should be set from the query itself.

The counting of records on the report can be obtained thru "count" reserve words in Jet engine keeping into a unbound textbox on the report. Like ;

=[Count]-30

where as you will have to play with the integer part including arithmetic operator (Only + or - ) according to the page length and then finally it will produce the result 1, 2, 3 and so on.

Hope this help.
Ashfaque

hoo ash,

 I don think so . pls try to clarify me again..

bye

bye
------------------------
pap...

Which part from the above is not "UNDERSTANDABLE" to you ?

Ashfaque

Ashi,

   Let me explain data field which iam having is Room No, Name of the Equipment ...etc.. The iam Sorting with room no.. ok . Then the Equipment will be differed as Computer , Laptop , Server , Printers , Scanner , ect and the data lies on the equipment name .. i want to take reportview equipment namewise .. and i did the report for that . when i run the query it ask me the equipment name and when i entered the equipment name then the report will appear what i wish.. its show's room no. , Equipment name in the Header , Model , Make PRice Who's having etc.. now what i need is an addition field which show the serial number before ..it is possible for me ]
pls explain & iam very tried to write this mess....



bye
------------------------
pap...

As I told you before add a unbound textbox to the detail section of your report and write the following into it.

=Count-30

Where as you can change the intiger part according to the length of the report. Alos in the property of ths text box goto Data---Running Sum and select Over Group (If you are grouping).

This will produce the result you wish to. If still doesn't work ....send your db file to me in ZIP mode with minimum records. I will see and let you know.

Regards,
Ashfaque

N. B. Field Names should be always WITHOUT any space.