Search results

I cannot for the life of me figure out how to put these two together in one calculated field. Type: "C.REGT.000" & [table1]![Field1] & "L - (Straight Time)" Left([table1]![Field1],Len([table1]![Field1])-1) :confused:

Wow, quick response...thank you. Does that go in the critirea portion of my calculated field or used in conjuction with the concatenated string I inserted into the calculated field?

I want to set up a calculated field in one of my queries. I need to concatenate characters to the beginning and end of my chosen field, this part I know how to do. What has me stumped is how do I remove a certain character. Here is what I have: Type: "C.REGT.000" & [table1]![Field1] & "L -...

This is exactly what I don't want to do. I would like to supress the records without having to manage the tables. Call me lazy, but there has got to be a way to do it without creating extra tables. I am a minimalist at heart. If the code you presented me is the only way to do it, then I'll use...

I would like to remove all duplicate records from a table I have setup. I have created a find duplicates query using the wizard which works great. What would I put in for a statement to add to the query that would delete the duplicates. It doesn't matter which record gets deleted as long as...

My world is right again! That worked perfectly. Thanks Mr. Larson!

This table will serve two purposes: A) Parameter query set for the "LastName" field for easy information retrieval (I don't want to use a param query for the combobox. I tried out of desperation.:confused: B) A field would be available for use in another form (The combobox that I want to set...

It's funny you ask that. My textbook I'm working with in Access has a solution just for that. It requires a module so I'm not sure if that's what you want. Anyway here is the code for the module. Function CapAll(FValue) CapAll = UCase(FValue) End Function Hope this helps!

That concatenated field would populate a combobox on another form not attached to this table. I do have a parameter query setup for the above mentioned table, but when I try to have that populate the combobox it asks for the "parameter", which I don't want for the combobox I'm trying to get...

I have a simple table setup with 4 columns which are from left to right: last name,first name, id, Full name I want to have the "full name" column display data from both the last name & first name columns. I'm using the full name column to populate a combobox in a form. I can concatenate in a...

I ended up exporting the tables to an excel spreadsheet and re-importing them back in and they worked. Probably not the best way to do it, but I needed it up and running. It must have been a formatting issue? I'll keep that in mind if it happens again Smig. Thanks.

I have a simple table and form set up. When I close access and reopen it all the records stored in my form are gone. The data still resides in the table it just disappears from the form. Is this normal? It happens to all my forms in this .accdb. It kind of defeats the purpose of having the...