J
Justin
I have this database where the user will select some data from a subform
to add comments. When adding comments, the database opens up another form
with that specific data he is adding the comments. Now I have a table that
has, in detail, all the specific data. Thing is that the number ID is
different. Let me give an example
Data he is pulling
Batch Number: 8893
Date: 8/30
Amount: $20.93
Now on my other table, it has all that same info. except that the batch
number is like 88932324545. I want to have a query where it will check the
batch number and shows every record that begins with that batch number
so if i had 10 records of 8893, i want to see that
i tried making a query and having in the criteria 'LIKE "*" '
but it shows all the record. i want it to show the batch number from the form,
to add comments. When adding comments, the database opens up another form
with that specific data he is adding the comments. Now I have a table that
has, in detail, all the specific data. Thing is that the number ID is
different. Let me give an example
Data he is pulling
Batch Number: 8893
Date: 8/30
Amount: $20.93
Now on my other table, it has all that same info. except that the batch
number is like 88932324545. I want to have a query where it will check the
batch number and shows every record that begins with that batch number
so if i had 10 records of 8893, i want to see that
i tried making a query and having in the criteria 'LIKE "*" '
but it shows all the record. i want it to show the batch number from the form,