In Excel 2007, I have the hardest time with CONCATENATE. I have 2 columns of text that I want to concatenate together (row by row). If in cell C2 I enter
=CONCATENATE(A2,B2)
the result is just THAT-- As if I had put quotes around the whole thing.
I have an Access DB of personnel-type info. The info originates online in different Excel files that are updated on different schedules. Each is renamed according to the date it was last updated. I cannot link the online files to the DB, so I have to save them to my computer and link or import...
I have a pdox table of some 3000+ records. I was trying to change the driver language and wound up with a corrupted table. I ran the table repair and wound up with only 378 records. Did this a couple times. Each time the 'copy of' table shows the correct size, but is mostly unreadable. The...
Is there a way to put a database such as Access or Paradox on the web for user query access, but not edit access? We would like to post searchable, cross referenced data.
I would like to put a combo box onto my form. The associated table has one field that has different spreadsheets as objects for some of the records. I would like the user to be able to choose a record from the first column (name of a publication), and see the spreadsheet of data in the 2nd...
Definitions please:
What is the difference between a composite index, composite key, vs primary + secondary index.
Is creating a composite key as simple as defining 2 fields as keys? I haven't seen any good how-to references on this.
I must have done something to hide the standard menu bar in Word. Control-V does nothing, right clicking only shows the short cut, paste, etc menu. I've tried right clicking all over the document and edges with no luck. Any other ideas? I looked in the MS office tools folder & it doesn't...
I have always been frustrated when excel moves the cursor. I have gone into Tools/Options/Edit, and then unchecked the 'move selection after enter' box. However that will stop it from moving for everything you do. (I suppose with programs also?)
I would like to write a program to change the table name in a query, and then run the query. The table structure will not change, nor will the checked fields.
Reason: I always forget the fields (predetermined) I'm looking for.
I created a 2 table query using a data model. It ran at the time I created it. Then I saved it for future editing and use, but when I try to call it up, I get the msg "Expecting consistent number of columns in all rows of table" The related Help, says it may have an incorrect # of...
I am trying to use the changeto command in a query to change a numerical (N type) field with a calculation. This would affect all the records in the table.
I get an error msg saying I am trying to link 2 tables (WRONG) and the fields are not the same type (number fields should have no...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.