Auto number in append query every time

[ootkhopdi]

Dear Sir
pls give me solution so i m very new in access and stage of learning as kid
i have a sample database created by self
it has a table name"List_Member"
i m using delete query to delete all data in that table and append query for append new data from master table name"Allmember
pls give me solution for
1- when i append data to "List_member", it should start with S.No.1,every time

thanks in advance
pls give me solution in simple tasks or language(With Example ,if possible)
Thanks once againg

Ootkhopdi

 

[RainLover]

Try deleting the existing table and then create a new Table.

To create a new table it is easy to have one already created then copy it with a different name.

 

[ootkhopdi]

Try deleting the existing table and then create a new Table.

To create a new table it is easy to have one already created then copy it with a different name.

Thanks.
But my Table gives a report
now i got the solution as
1-delete all records in table using delete query
2-set autonumber start with 1,using append query
3-then append data ,using other append query.

Thanks

 

[RainLover]

Thanks.
But my Table gives a report
now i got the solution as
1-delete all records in table using delete query
2-set autonumber start with 1,using append query
3-then append data ,using other append query.

Thanks

Does this mean you have found a solution that works for you or do you need more help.

I can see a problem that this table will cause bloat. However if you have this under control then that is fine.

 

[ootkhopdi]

Does this mean you have found a solution that works for you or do you need more help.

I can see a problem that this table will cause bloat. However if you have this under control then that is fine.

No sir
i have a solution but it is lengthy process and run multi query and make tables
pls provide me any other simple solution in one query

 

[RainLover]

I think your solution is a lengthy process because your approach is not normal.

Please tell why do you wish to delete all the records before each import of new records.

 

[ootkhopdi]

I think your solution is a lengthy process because your approach is not normal.

Please tell why do you wish to delete all the records before each import of new records.

Sir

I want to create a report based on a query
because i m a beginer in access
so i follow below steps to find my data
1-run query for select desired record
2-make a table for create report and data show in form
3-then again ,if i m change in main form to create other report , i cant return my result for other values
so that i m doing all my process ,like delete record, then append record,,
and finally get list or report my my filtered data

i m a very beginner and unknown with vb and sql ,,but trying to get knowledge of these ,,,
pls help me if u have any other simple process for that
i m also reuest to all persons for this,and pls help me with examples (if posble with pic and database)
ootkhopdi

 

[RainLover]

I would like to help you more however your lack of knowledge in this area is too large and you are asking for quite a lot.

I would suggest that you Google Access and look for some tutorials. Also articles on Normalisation would help with your table design and also learn some basic naming conventions.

Purchasing a book on the basics in a Tutorial form would also help.