Multiple Entries for the same key in an access DB

[scorpio]

Hi everyone,

i have an emp id say p12234
and an entry for this id has been made into the access DB.

now i want to add another record for the same key (there is no primary key set)

such that the output appears as :

emp_id name qty date
p12234 p 1 30/03/2007
p12234 p 2 31/03/2007

plz help to write the query for this.....

[dorinbogdan]

Welcome to TheScripts TSDN...

Suposing that the table name is employee, execute this query:

Insert Into employee (emp_id, [name], qty, [date])
Values ('p12234', 'p',2, '31/03/2007')
 

Replace employee with your real table name.

Does it solve your problem?

[scorpio]

Welcome to TheScripts TSDN...

Suposing that the table name is employee, execute this query:

Insert Into employee (emp_id, [name], qty, [date])
Values ('p12234', 'p',2, '31/03/2007')
 

Replace employee with your real table name.

Does it solve your problem?

Hi Sir,
Actually d scenario is I've designed 1 snacks order system. in this everyday employee in our company order for snack's qty. now in this im takin d current date. d problem is, any employee id entered for d 1st time while saving d record in d DB doesnt throw any error but if on next day if i try to enter snack's qty on same employee id, it dosnt take that data and shows a blank screen (not any error).
since there are multiple entries for d same key I've not assigned primary key to d table...

now how should I proceed??

[dorinbogdan]

Please provide your code.