Kamis, 23 April 2015

Re: [MS_AccessPros] Re: Query or a report?

 

I went to the group site and then FILES.  I did not see an upload option.  


On Apr 23, 2015, at 4:24 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


Jan,
You can visit our group on the web and upload files to https://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/2_AssistanceNeeded/.
 
If your table is linked, it is best to import the file into the uploaded file. Otherwise you need to upload multiple files.
 
Duane Hookom, MVP
MS Access
 

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 23 Apr 2015 16:05:50 -0600
Subject: Re: [MS_AccessPros] Re: Query or a report?



No attachment. I don't know how or I don't have access to upload a file. 

On 4/23/2015 4:01 PM, jan.hertzsch@gmail.com [MS_Access_Professionals] wrote:
 
Hi Duane:


I just checked out the crosstab query.  It appears to allow me to put up to three fields of information on the left hand side and one field of information as a column across the top. 


I set the rows to be unique for  Contact_ID, Contact_Lastname,Contact_Firstname and email for column. 


It put every email I have across the top as column headings with the number of occurrences for each row. 


Looks like a pivot chart on steroids but not what I am seeking.


I uploaded an example of what I want to get out. look at the email and status columns.  Right now, I get one line for each email and one for each status with Name and address duplicated. 


Thanks... 






__._,_.___

Posted by: Jan Hertzsch <jan.hertzsch@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)

.

__,_._,___

Tidak ada komentar:

Posting Komentar