Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2008

Tip: Looking for answers? Try searching our database.

Help with Reports

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
teelee - 26 Mar 2008 23:35 GMT
I have a few ways where a product can be sold, I want to be able to create a
report in a way that I can view the product and the certain way it was sold.
Can this be done?

Thanks in advance
Duane Hookom - 27 Mar 2008 03:27 GMT
I expect this is possible. Is it possible to share at least a little more
about your mdb?

Signature

Duane Hookom
Microsoft Access MVP

> I have a few ways where a product can be sold, I want to be able to create a
> report in a way that I can view the product and the certain way it was sold.
> Can this be done?
>
> Thanks in advance
teelee - 27 Mar 2008 13:54 GMT
I have products and they can be purchased is these 3 ways, Direct Bill, Web
Charge, EPlans. I want to be able to select the product then select which way
it was purchased on a report. Hope this helps.

Thanks

> I expect this is possible. Is it possible to share at least a little more
> about your mdb?
[quoted text clipped - 4 lines]
> >
> > Thanks in advance
Duane Hookom - 27 Mar 2008 14:21 GMT
Ok, so you need to provide a lot more about your mdb and your needs. Can you
share some table names and structures with the data types of significant
fields?

Do you simply want to be able to filter a report to a specific Product and
Purchase method? Have you already created a report for this?

Signature

Duane Hookom
Microsoft Access MVP

> I have products and they can be purchased is these 3 ways, Direct Bill, Web
> Charge, EPlans. I want to be able to select the product then select which way
[quoted text clipped - 10 lines]
> > >
> > > Thanks in advance
teelee - 27 Mar 2008 14:33 GMT
I have a table with Products that has cost of product and the way it can be
purchased, a customers table with customers info, a Purchase method table in
the way the product can be purchased, I also created a table for a form
instead of a switchboard that has command buttons to select forms, and
reports. On my reporting form you would select which report to view by
selecting the product name along with the date in which you would like to
see. What I'm trying to add on this form is a combo box where you can select
the purchase method on the way the product was sold. In other words if I want
to just see the web charge products on my report. Hope this works.

Thanks

> Ok, so you need to provide a lot more about your mdb and your needs. Can you
> share some table names and structures with the data types of significant
[quoted text clipped - 17 lines]
> > > >
> > > > Thanks in advance
Duane Hookom - 27 Mar 2008 15:03 GMT
How does "select the purchase method" differ from "selecting the product name
along with the date"? Can't you apply the same method used for the product to
the purchase method?

Signature

Duane Hookom
Microsoft Access MVP

> I have a table with Products that has cost of product and the way it can be
> purchased, a customers table with customers info, a Purchase method table in
[quoted text clipped - 29 lines]
> > > > >
> > > > > Thanks in advance
teelee - 27 Mar 2008 23:59 GMT
When you select the Product I want to be able to select the way the product
was sold, which is Direct Pay, Web Charge, or E Plan which is under the
reports to select. I guess I can apply the same method used for the product
the only thing is I'm not sure how to.

Thanks

> How does "select the purchase method" differ from "selecting the product name
> along with the date"? Can't you apply the same method used for the product to
[quoted text clipped - 33 lines]
> > > > > >
> > > > > > Thanks in advance
Duane Hookom - 28 Mar 2008 00:16 GMT
If you would provide the information on how your report is currently filtered
by Product and date range, then someone might be able to help you apply the
same method to your purchase method. It's a bit difficult when we can't see
your database. You need to tell us.

Signature

Duane Hookom
Microsoft Access MVP

> When you select the Product I want to be able to select the way the product
> was sold, which is Direct Pay, Web Charge, or E Plan which is under the
[quoted text clipped - 40 lines]
> > > > > > >
> > > > > > > Thanks in advance
teelee - 28 Mar 2008 00:35 GMT
Where do I check for the filter?

> If you would provide the information on how your report is currently filtered
> by Product and date range, then someone might be able to help you apply the
[quoted text clipped - 45 lines]
> > > > > > > >
> > > > > > > > Thanks in advance
Duane Hookom - 28 Mar 2008 00:48 GMT
Go to Allen Browne's web site http://www.allenbrowne.com/tips.html and read
the first couple tips for casual users under reports.
Signature

Duane Hookom
Microsoft Access MVP

> Where do I check for the filter?
>
[quoted text clipped - 47 lines]
> > > > > > > > >
> > > > > > > > > Thanks in advance
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.