Search results for query: *

I'm having trouble creating an input mask to capture the year. I stepped through the Input Mask Wizard and enteredthe following data: Description: Year Input Mask: 0000 Placeholder: _ Sample Data: 1987 MAsk Type: Date-Time This seemed to work in the test, but when I attempt to enter...

we don't have a vendor table because a many products come through a single supplier, so presently that is how they are seperated. What you propose should work in most instances. As I said before I don't need a single statement to cover all eventuallities as I have aleardy done some of the...

Richard, The format of the SKU actually changes depending on the vedors SKU. The reason I need to prefix our code to these SKU's so our bookeeping department can seperate them easily. For the most part the SKU will begin with two to three characters. A couple of examples are: HB197.63N.097...

Robert, Thanks for you help. I've just realised I left off a couple of important points. 1) I need to a SQL UPDATE as the database is located on our web server. Can you help? 2) I need to remove the first two characters of the SKU, prior to adding the new prefix. TIA, Steve

I have a table with a column named SKU (text). I need to prefix SOME of the records in this column with a 3 digit number. Can someone please provide me with the update code to retrieve the current value and prefix three digits to this value. I am using Acess 2000 TIA, Steve