Search results for query: *

I guess i should start at the beginning. I have table with my information(obviously), and i have a startup form which is automatically activated when access opens my database. The for has several buttons, but the one of importance is the "find now" button. It opens another form; that...

I've attempted unsuccessfully twice to append, well really once to append and once using the 2 tables to make a new table. Anyway, the append query makes more logic to me though i am not real familar with sql, but i have had significantly more success with creating a new table from the existing...

i want to eliminate some slashes in a table and not every record has one and some even have two...(go figure), could i possibly use a query to apply a filter to table X that lists all the entries that have a \ in it and then eliminate the \'s according to the results of the applied filter? Would...

UPDATE X SET Source_ID = left([Source_ID],10) & "\" WHERE x.Image_Source = "\Images\Rollfilm\"; This is a copy of my query i have to insert a "\" at the end of my column. Though when ran only about 1/3 of the cells in the column recieved a "\". I'm not...

greetings, i wish to add a "\" to the last four digits in one column and doing the process manually is insane since there is a little over 500,000 entries. How would the SQL look on a statement like that? Thomas Gunter Network Administrator

UPDATE Y INNER JOIN X ON ([Y].[Column1]=[X].[Column1]) AND ([Y].[Column2]=[X].[Column2]) SET X.Info = [Y].[Info]; This is the query that i have,it looks at column1 and then at column2 for matching information and then updates the info field with the correct information...the only problem is...

Greetings, Currently i am working on a database for a client and the actual database is hidden, and when the database is opened a form is opened that has all the options and uses the employees need. However a few insist on unhiding the database and looking around and end up causeing a...

Greetings, Currently i am working on a database for a client and the actual database is hidden, and when the database is opened a form is opened that has all the options and uses the employees need. However a few insist on unhiding the database and looking around and end up causeing a...

I used the query written below (created with the help of a MS Access programmer named bill) and it works on my other database with different table names (Microfilmlibrary1 & main1 are the table names used that create the conflict). I've tried so many different avenues but every time i run any...

I am creating a query that uses a secondary table to update the main table, the catch is that only two columns are alike and then there will be a third after the main table is updated. What i would like to do is have the query look at the two columns that are alike, and then match the...

My Query: If [Image_Source] = "\Images\Not Available\" Then If [Source_ID] = "37**" Or "38**" Then Set [Image_Source] = "\Images\Microfiche" I'm aware that this is writtten horribly wrong, but as i am not acquainted with using SQL to write queries i think...

Greetings all! I am by no means a professional grade programmer and in fact have only a limited understanding of the matter. I entered a joint venture with a programmer to create a database. It consists of 500,000+ data entries and each is linked to a picture of the actual document. Recently my...