Search results

Hi all, I have a select statement liek this one: Select * from table1 where lastname LIKE 'var1%' and firstname LIKE 'var2%' and address LIKE '%' My problem is that the select will not return those records where address is null! Is there any way to overcome this without converting all the...

can you elaborate please? Hi Wayne, Thanks for your answer on Christmas day. Well, I can't think of how a simple query can do this. Lets assume I have only 3 fields, ID, firstname, lastname, and I want to move firstname,lastname from ID 10 to ID 11. update mytable set firstname=...

Hi, I have a table and want to copy the values from one record to another. For instance I want to copy all the values from record with ID 100 to record with ID 110. Why would I want something like that? Because a user mistakenly placed the record at 100 instead of 110. Then the 100th record...

Hi all (and Merry Christmas). I have an insert query. When the user clicks save, I want the insert statement to return the number from the ID field of the table which is autoincrement (and is auto completed by the database). The problem is that the database sits on a server and many users use...

Hi, I have a table that was inserted from excell. The problem is that some columns appear left justified and some right justified, while I want all to be left justified. if i try to write something on a column that appears as right justified the cusror starts from the right. The same applies...

sorry for the trouble i put you. I should have been more clear. George

As I said i figured it out Hi, If you notice my second post you will see that I figured out what the problem was on my first post, and I mentioned the solution on the second. So the second is correct. The first one not. Anyway, thnx for your interest. George

Figured it out Well I have to join the two tables based on the common field, then do the set. Here it is: UPDATE TABLE1 INNER JOIN TABLE2 ON [TABLE1].[ID]=[TABLE2].[CARD_NUMBER] SET [TABLE1].NAME = [TABLE2].NAME

Hi all, I want to update the columns of one table to the columns of another table based on a common field. This is what I tried but it's not working: UPDATE TABLE1 SET TABLE1.NAME = TABLE2.NAME WHERE TABLE1.ID=TABLE2.CARD_NUMBER (ID and card number are unique, card numbers is a subset of id...

Thnx Pat, everything is clear now

Hi Pat, Quoting you from another article that I found: "Using DMax() to find the most recent sequence number and adding 1 to it to obtain the next number may sound like a simple solution but if your people are really doing simultaneous data entry, that code is quite likely to generate duplicate...

Hi all, One of the columns in my database is a protocol number. This number has to increment by 1 each time there is a new entry, and has to be unique. The problem is that this database has already protocol values and is accessed by many clients. So just finding the last protocol and...

Hi Guys, Sorry for posting also here and to excell but it's related. When I try to import an excell sheet that has dates in the form 19/9/03 to access, I get type conversion failure. If the date is 19/09/03 then it works fine. I have also one other column with numbers. If there is space between...