Search results

I have a query that does an inner join. I want it to just pull in the first match from the second table in the event there are multiple matches. How do I limit the query to only pull in the first match found for the rcust.CustID? Thanks for any help. :confused::confused: SELECT...

Okay, I have been screwing around with Joins and Unions and can't quite get this right. I have one table I am trying to update with information from 2 others, but I can't get this working. I need to say something like this: UPDATE Table1 SET Table1.CustId = Table2.CustId, Table1.FirstName =...

I have a table that someone created that for whatever reason they put the text CustID= into the UVAR field instead of just the ID number. The other thing that I noticed is that there several spaces between CustID= and the customer number. So, it may be in one time as CustID= 12345 and the next...

I have a client with an access 2003 database and I need to change something for them. I normally work in php mysql so I am a little out of my element. They are submitting a form that processes and checks for fees. They have a sale number that is normally based on the date. 20080612 for...