Hey Crystal...
I'm not too shure as to how to proceed with your advice. I don't understand what you mean by going to the sources. I'll post a sample of the db in asistance needed so you can see what I have. That code you gave me kinda makes scence but I don't know where to put it or what to do with it...
Edgar
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Edgar,
>
> it is nice to hear such enthusiasm! Rather than building on queries that are already there... go to the sources. I say that since I am not familiar with your database ... it is just too easy to make too many queries! Later on, after the development is to a plateau (never done ;), you can optimize the queries you are using.
>
> try something like this:
>
> SELECT fieldname1, fieldname2, fieldname3, ServiceDate
> FROM tblInventory
> WHERE
> Month(tblInventorytblInventory ServiceDate) = 7
> AND Year(tblInventory.ServiceDate) = 2011
> AND CustID IN (SELECT CustID FROM Addresses WHERE City = "San Juan")
> AND CustID IN (SELECT CustID FROM Customers WHERE IsActive=True)
>
> WHERE
> - ServiceDate is the fieldname in tblInventory that you are filtering on
> - City is the city field in your Addresses table
> - IsActive is in your Customers table.
> - IsActive=True represents the logic to get active customers
>
> Once you get the query working, add other tables to the design to get other information like customer name
>
> ~~~
>
> this is not the most efficient way ... the master of SQL is John so if he gives you something different, I'd go with it ;)
>
>
> Warm Regards,
> Crystal
>
> Access Basics by Crystal (Bill Mosca's site)
> http://thatlldoit.com
> Free 100-page book that covers essentials in Access
>
> *
> (: have an awesome day :)
> *
>
>
> --- On Thu, 6/30/11, rivera_vazquez_edgar wrote:
>
>
> > Hello again to everyone!
> >
> > I've taken off like a rocket with this database, and
> > there's no stopping me! That is, if you guys give your usual
> > support...
> >
> > I need to make my report. I call it "The Rute" because it
> > should be made up of all the customers that have a service
> > due for the current month in a given city, so I know who to
> > visit. So I need a single report for every city I choose to
> > print. But the thing is, I need to figure out how to
> > structure the report so I know what queries to make.
> >
> > The idea I have is the following, please correct me:
> >
> > Make a report using qryActiveCustomers with a subform using
> > tblAddress to show the address for each active customer and
> > a sub-subform for the inventory of that particular
> > address. The thing is, the tblInventory is the one
> > that has the service due date in the field "NxtServDate".
> > How would I filter it so I only get, for example all the
> > customers in the city of San Juan with a next service date
> > of July? The parent form would have to be filtered by the
> > grandchild form, is this posible? If so, How?
> >
> > I'm thinking of using a user input in the qryActiveCustomer
> > to ask for the City name...
> >
> >
>
Tidak ada komentar:
Posting Komentar