Re: SQL Query Help!

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 17:33:26 -0400

http://www.aspfaq.com/show.asp?id=2462

"Ali" <aliasgerj@hotmail.com> wrote in message
news:%234iEFzUXEHA.3640@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I have a table, with the following Fields and Values:
>
> Table: Products
> Fields: ProductNumber,Location, Quantity.
>
> The product numbers can repeat, with different locations, and quantities.
> Hence product number 123456 can be entered twice, once for lets say, UK
> location, and another for US location.
>
> The problem i have is, how do i make a query, that will show result with
> following Colums: | Product Number | UK | US | Quantity |
>
> As far as location is concerned, there are going to be two locations only,
> UK and US all the time.
>
> Thanks,
>
> Ali
>
>

Relevant Pages

  • SQL Query Help!
    ... The product numbers can repeat, with different locations, and quantities. ... Hence product number 123456 can be entered twice, once for lets say, UK ... The problem i have is, how do i make a query, that will show result with ... Ali ...
    (microsoft.public.sqlserver.datamining)
  • Re: Populating a field
    ... If you already have the data in 1 location, you never need to repeat it. ... A query joining the 2 ... I shuld have mentioned the report. ... Sub cboWhatever_AfterUpdate ...
    (microsoft.public.access.forms)
  • Re: need certain form data to repeat for several records
    ... The answer to your question is NO. Create your query. ... design view. ... Base your form on a query designed to repeat ... same control source as another control on the form. ...
    (microsoft.public.access.gettingstarted)
  • Re: What is the character limit in variables?
    ... I had to do this because the query text pieces sometimes exceed ... In the calc dialog, I am not aware of character limits, though there may be some lingering limit to nested Ifs, which no one should be using anyway. ... If you enter data in Repeat 1, and other data in Repeat 1million, the intervening empty repeats do not consume any memory. ... For various limited purposes they will behave properly when extracting data, as if they were of type number or date, but if you put mixed data types IN, and then try to extract it, you may have to use various GetAs typing functions to extract it in the proper form. ...
    (comp.databases.filemaker)
  • Re: Repeat Print
    ... > Have a report based on a query. ... > wanted were to have Pallet# repeat every four records. ... > repeat records then it goes to four again. ...
    (microsoft.public.access.reports)
Loading