Recent content by PAWelch

When uploading a document is there a way to prevent the word "NEW' next to the document?

Yessir! Three! You had #3 up there before I could finish my "thank you". Quick on the draw! Thank you, Harley.

Both suggestions look doable for my not-so-nimble brain. Thank you so much!

All email addresses are in one column. Which now explains why it's in "list" formation. (I really need less coffee in my day...) Any suggestions on what to do when all the data is in one column? I appreciate your grace with my lack of knowledge. Thank you.

I opened it up using NOTEPAD and "all files" as only choices are that and .txt. It looks like a list, no commas.

I need it to come back like: joejones@marny.com,suzyq@marny.com,pbrain@marny.com.... But this thing looks just like a spreadsheet. So where are the commas? I've searched the forum here, MS Help... argh!

I have little experience with Excel. Boss needs a list of email addresses but with commas so he can cut and paste a slew of addresses into email address box and shoot out a meeting announcement. I've got all the email addresses in one column of an Excel spreadsheet. I tried to SAVE AS a csv...

Thanks, fellas! I used the UPDATE formula and it worked. I'm going to add the others to my book and try them out on my table copies. Geez, I need to learn so much more!!! Thank you!

Please excuse my ignorance but how do I make that a query? In SQL view (MSAccess 2003), I entered: SELECT PDRT.EvaltrID FROM PDRT right("0" & CStr[PDRT.EvaltrID], 6); It comes back with a Syntax error in JOIN problem.

For one-time use only. I have a text field in a table that contains ID numbers. The client wants all IDs to be 6 characters though 15 are allowed. At present, some are 6 and others have only 5. So leading zeros must be added to those that are only 5 characters. I've seen some tips on doing...

The actual name of the field in my table is "EvalDate". I put "Month" as a more generic term and the mm/yyyy was just to let you know how it was formatted. Sorry for the confusion. I will be more accurate next time. Thank you all.

Thank you very much. I will give this a shot! Do you have a book you would recommend for learning Access 2003?

The data is stored by month. Table structure: Month (mm/yyyy) StudentID ProjectID GradeAssigned It is possible that not all grades will be used. The count of grades assigned needs to be done quarterly. Individual teachers are not to be in the report. ProjectID's are not in the report. I...

I am a novice with Access, building only basic reports, no programming background. I must create a report that totals the number of 5 different grades that teachers dole out and what percentage of the quarterly total does each grade receive. It needs to look like this: Qtr 1 A 25 13% B 84...

I am a novice user of Crystal 9.0. I am tasked with designing a report to be used by multiple clients. A crosstab report is to show a grade scale that can vary-some clients use 0-4, some 1-8. The goal is to display the instructors' grade distribution-are they using the entire grade scale? All...