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...
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.