Hi;
i designed a database
it is controlling the stock and the test results
but there is a problem when i was using the query
because i entered the table data like
"1111 Microsoft Access"
"2222 Microsoft Excel"
when i executed the query i must enter the exact data like "1111 Microsoft Access" but i wanna only use "1111" for executing the query.

Please help me how can i do that?

Thanks for your Help.

You may want to consider normalizing your database structure first. You are likely to have a lot of problems like that if you don't. If you still want to try a quick fix, can we see your query so far?

For example
i gave the RAMs a code and the title
30046805 DDR RAM 256MB PC3200 (400)
when i started the querry for the RAM Code
query wants to be entered the code and title
30046805 DDR RAM 256MB PC3200 (400)
but i want to enter only 30046805
Can i do this
by changing query criteria?

Please help me..

Your question is criptic, meaning I don't understand, perhaps somebody else understands what you are asking. Again, can you show us the SQL from your query?

when i executed the query i must enter the exact data like "1111 Microsoft Access" but i wanna only use "1111" for executing the query.
For partial match, you can use the Like operator in the criteria for the field:-

Like [Enter code eg 1111] & "*"


But normally we would put the code and the description in two separate fields in the table, not in one single field.
.

Can i execute the criteria in the access like value list and list box?
i can not do what i want in separating the code and name ; but maybe i can selecting