how do i create a new record for a certain criteria?

[Net]

I would like to create a new record for each loan number that is in a certain
criteria/status. Would this be an IF statement? Thank you.

 

[John W. Vinson]

I would like to create a new record for each loan number that is in a certain
criteria/status. Would this be an IF statement? Thank you.

Probably not; it would be an Append query. But you are assuming that we know a
lot more about your database than you have posted, which we don't.

 

[Net]

This is my first time doing this
Let me give you more background - My database is to keep track of Soldier &
Sailor reimbursements. I recieve a quarterly report which I import into my
database for any reimbursement that is due which is called Status 50. There
are other status codes but the only one that I want is 50. What I want to
happen is when I import the report, I want a new record created for any loan
number that is within the Status 50. Does that make sense? Thank you for
your help.

 

[John W. Vinson]

This is my first time doing this
Let me give you more background - My database is to keep track of Soldier &
Sailor reimbursements. I recieve a quarterly report which I import into my
database for any reimbursement that is due which is called Status 50. There
are other status codes but the only one that I want is 50. What I want to
happen is when I import the report, I want a new record created for any loan
number that is within the Status 50. Does that make sense? Thank you for
your help.

Again:

I'm sitting in my home office in Idaho; I can't see your screen. You're
describing the "business" side of your application, but nothing about its
actual structure!

What is the structure of your table or tables?
What are you importing the data into, and how?
What do you mean by "any loan number that is within the Status 50"?
What table do you want to have a new record?