Search results for query: *

thank you for trying to help me. here's my modification of your code: =(SELECT Count(*) FROM [tbl Data Log2] WHERE [tbl Data Log2.Customer] = [Customer] AND [tbl Data Log2.Start Date] = [Start Date] AND [tbl Data Log2.Test No]<=[Test No]) add it to to the query. RESULT: it has 3889 as...

ok. on a 2 X 4 Avery label Example: Test No: 1234* Start Date: 1/22/09 Customer: ABC Size: 7-8 * color: Dark brown* Style: 2133* Description: test sock* 1 of 3 (would like to have this done; group sample 1 of 3, 2 of 3, etc) *will be different for all 3 sample; customer and start date...

Dhookom the link you provide works ok; however, it is for the same customer with the same type of style#, color, size, etc. in my case, i may received 10 items from the same customer and each of the items have to have its own unique test#; yet, i have to keep them as a group. That was why I...

Some customers would send us 10 samples at a time. I have a fieldname in the database to store the number of samples send as numeric. How do I write the code so that it'll display as "sample 1 of 10", "sample 2 of 10", etc. thank you.

I would like to display the label of a field name only if the value of the field name exist. Can it be done in Access? If yes, how? Lots of Thanks! :)

ignore the attach url. got it to work. :)

Thank you! It works! :)http://www.hosetech.com/error.gif

Still got the same error message. I already check in the database to be sure that I do have data in it and it does. any other ideas? Thanks

ok. Then in the 'control source' when create a report, is it possible to write a simple code that says if the values of the field name is not empty (no matter what values it is in it); then write 'abrasion'. if the field name value is empty then don't write anything. I try this code...

I have two table (created by someone else). One contains the date, order number, customer name, etc. The other table contains the test methods perform and it store values. click on url. I create a query (to be used as report later) and would like to use the 'Field Name' such as...