Conditional data display

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bill Schroyer (bill_at_frontpagewiz.com)
Date: 06/19/04 

Date: Sat, 19 Jun 2004 06:40:45 -0700

Create a query (view) in access to count your locations.
Use the FrontPage Database Results Wizard to display the
query. You can position the new results relative to your
main DRW using layers, or an iframe. Change the "No
Records Returned" to "Out of Stock".

Bill Schroyer
bill@frontpagewiz.com
http://www.frontpagewiz.com
>-----Original Message-----
>I'm using ASP to display data from my Access DB and I'm
stumped about how to
>do the following:
>
>I have two tables. One lists nursery stock and the
other lists locations
>where each stock item can be found. I think I understand
how to use the
>Count operator to present a column which shows how many
locations exist for
>each stock item but what I really want to do is to
present a column that
>says "Out of stock" if there are no locations and shows
how many locations
>there are if there are one or more.
>
>Can anyone give me a push in the right direction?
>
>--
>Dennis Gallagher
>Monroe, WA, USA
>
>
>.
>

Relevant Pages

  • Re: Question on displaying repeating data
    ... "Rich" wrote in message ... > enter/display opening and closing stock prices for a given company. ... The query logic is relatively simple. ... > My problem is that I don't know how to display this. ...
    (microsoft.public.access.forms)
  • Re: Displaying fields in a stock table
    ... Hi Steve. ... added a non visible column that was bases on StockID in the Stock Table. ... various forms linked to the Query allong with the correct Serial Numbers ... Box to display the Make/ Model text that is associated with the ID by ...
    (microsoft.public.access.gettingstarted)
  • Re: Displaying fields in a stock table
    ... in the stock Table and I added the Stock Table ID but did not male it visible ... in the query design view. ... table and ModelID joined to ModelID in the Model table. ... Box to display the Make/ Model text that is associated with the ID by ...
    (microsoft.public.access.gettingstarted)
  • Re: Displaying fields in a stock table
    ... Your Stock table looks something like this: ... table and ModelID joined to ModelID in the Model table. ... In your query, include all three tables. ... Box to display the Make/ Model text that is associated with the ID by ...
    (microsoft.public.access.gettingstarted)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)