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 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.
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...
[OS-WinXP Home]
I'm trying to load some example files from a CD onto my C Drive. In the Install process, a message pops up and says "UNWISE.EXE Could not be opened. Please check that your disk is not full and that you have access to the destination directory."
Well, I've got 20G free...
When I try to print out a report in PDF Writer, the text looks like Russian alphabet. It looks fine in PDF Distiller. I had no problem like this when using CR 8.0. Because of the length of my reports, I prefer PDF Writer as Distiller makes huge files. The only fonts I use in CR are Times New...
I have a report generated by a simple Access query. All it does it display the grading averages of teachers and how many tests they graded as well as a bar graph based on the grading average. I need it to sort by the grading averages descendingly. It sorts appropriately in the query but not...
Using CR 9.0 with MS Access 2000 application on Win2000 platform.
When selecting PRINT to PDF, the report in PDF is totally garbled. Letters and numbers laying on top of each other. The Dollar Sign has taken the place of all A's. These reports worked perfectly before our recent upgrade to CR...
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.