RE: [AccessDevelopers] Re: creating a table of data based on other table

2005-06-28 Thread Crosier, Dawn
Developers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon Sent: Tuesday, June 28, 2005 11:15 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Re: creating a table of data based on other table I was able to use a Crosstab Query which gives me mostly what I want... e

[AccessDevelopers] Re: creating a table of data based on other table

2005-06-28 Thread Brandon
I was able to use a Crosstab Query which gives me mostly what I want... except that the query is unaware of months that have no value for any vendor.. a minor problem, but it doesn't allow me to make a static rpt very easily. I think it will work though. :Brandon: --- In AccessDevelopers@yaho

[AccessDevelopers] Re: creating a table of data based on other table

2005-06-28 Thread Brandon
Yeah... I tried it earlier and couldn't get it to work right. After your suggestion I went back to the drawing board and I think it got it to work. Except, how do I get around not being able to pass parameter to the query so that It limits the information going into the Crosstab? I am actuall

[AccessDevelopers] Re: creating a table of data based on other table

2005-06-28 Thread Brandon
Actually, I am having trouble getting the information in the form that I need to manipulate the information. Crosstabs (of which I have no experience) has been mentioned as a way to get the report I need in regard to the table that I have without 'reforming' the access to the data. :Brandon:

[AccessDevelopers] Re: creating a table of data based on other table

2005-06-27 Thread torres0157
Brandon, If I am correct, the problem you are having is placing a missing month on your report with a blank or special character. "is this true" Mando --- In AccessDevelopers@yahoogroups.com, "Brandon" Brandon, <[EMAIL PROTECTED]> wrote: > I am having difficulty preparing data for