Ratedness
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 49 articles for 0.303 sec
This one is making my head hurt. Any help will be much appreciated. I have an online database that field reps use to enter new clients and record client payments. I have a batch file that downloads the data in an .mdb file, and queries in another .mdb file that is linked to the tables in the downloaded file. The queries generate the invoices that we mail to the clients. The tables     

Group: microsoft.public.access.queries · Group Profile · Search for Ratedness in microsoft.public.access.queries
Author: Craig
Date: Jul 31, 2008 09:55

Karl, Thank you very much. Your queries worked perfectly. Cheers, Matthew "KARL DEWEY" wrote: This should start you off -- Rates -- Curr RateDate Rate Low High EUR 1/1/2006 1.41 10 15 USD 1/1/2006 1.8 16 20 USD 3/1/2006 1.81 21 30 USD 4/1/2006 1.82 31 45 USD 5/1/2006 1.83 46 99 Txns -- Refce TxnDate Curr Amount 10 3/21/2006 USD 10.87 11 4/10/2006
Show full article (1.37Kb)
This should start you off -- Rates -- Curr RateDate Rate Low High EUR 1/1/2006 1.41 10 15 USD 1/1/2006 1.8 16 20 USD 3/1/2006 1.81 21 30 USD 4/1/2006 1.82 31 45 USD 5/1/2006 1.83 46 99 Txns -- Refce TxnDate Curr Amount 10 3/21/2006 USD 10.87 11 4/10/2006 USD 20 TxnsRateDate -- SELECT Txns.Refce, Txns.TxnDate, Txns.Curr, Txns.Amount, Max(Rates.RateDate) AS MaxOfRateDate FROM Txns INNER     

Group: microsoft.public.access.queries · Group Profile · Search for Ratedness in microsoft.public.access.queries
Author: Matthew
Date: May 8, 2008 10:15

Bob, Create another table (tbl_Numbers) with a single field intNumbers containing values from 0 to 9. Create a query (qry_Numbers) from this that looks like: SELECT Tens.intNumbers * 10 + Ones.intNumbers as intNumbers FROM tbl_Numbers Tens, tbl_Numbers Ones This query will now give you the numbers from 0 to 99. Your new query will look like: INSERT INTO tbl_Transactions (RateDate
Show full article (2.09Kb) · Show article thread
> det hedder NiCd batterier og ja - du kan godt erstatte med NiMH - men du > kan IKKE bruge den samme batterilader... > eller hvis laderen er indbygget i babyalarmen kan den ikke bruges til at > lade NiMH batterierne med! Det afhænger af så meget... I gamle dage var det fin latin at NiCd batterier bare kunne lades med max 1/10 af deres ratede kapacitet uden synderlig kontrol. Var batterierne     

Group: microsoft.public.access.queries · Group Profile · Search for Ratedness in microsoft.public.access.queries
Author: KARL DEWEY
Date: May 8, 2008 08:33

"Retief" <nospam@invalid.invalid> wrote In your case, "science" traffics only in lies...such as the ones you persist in posting. Lies like this one? Tundra Disappearing At Rapid RateDate - March 7, 2007 ------------------------------------- University of Alberta The boundary, or treeline, between forest and tundra ecosystems is a prominent landscape feature in both Arctic and mountain
Show full article (1.86Kb) · Show article thread
<jimp@specsol.spam.sux.com> wrote > He probably got it from reading a history book. The temperature drop over the 800 year period was .4'C attributable to solar factors. The temperature rise over the last 50 years has been .75'C unattributable to enhanced CO2 levels. Tundra Disappearing At Rapid RateDate - March 7, 2007 ------------------------------------- University     

Group: microsoft.public.access.queries · Group Profile · Search for Ratedness in microsoft.public.access.queries
Author: Dale Fye
Date: Feb 22, 2008 12:59

On Mar 21, 8:43 am, MikeSoja <mso...@newsguy.com> wrote: On Tue, 20 Mar 2007 22:11:07 -0800, "Vendicar Decarian" <BushIsATrai...@hotmail.com> posted: <last_p...@rogers.com> quacked.... But the main reason is "tectonic activity" deep under the sea. So much for stupidity. Meanwhile.... Tundra Disappearing At Rapid RateDate - March 7, 2007 ---------------------
Show full article (1.89Kb) · Show article thread
On Mar 21, 8:43 am, MikeSoja <mso...@newsguy.com> wrote: > On Tue, 20 Mar 2007 22:11:07 -0800, "Vendicar Decarian" > <BushIsATrai...@hotmail.com> posted: > > ><last_p...@rogers.com> quacked.... > >> But the main reason is "tectonic activity" deep under the sea. > > So much for stupidity. > > Meanwhile.... > >Tundra Disappearing At Rapid RateDate - March 7, 2007 > >---------------------     

Group: dk.teknik.elektronik · Group Profile · Search for Ratedness in dk.teknik.elektronik
Author: Morten
Date: Jul 13, 2007 06:36

On Mar 21, 8:43 am, MikeSoja <mso...@newsguy.com> wrote: On Tue, 20 Mar 2007 22:11:07 -0800, "Vendicar Decarian" <BushIsATrai...@hotmail.com> posted: <last_p...@rogers.com> quacked.... But the main reason is "tectonic activity" deep under the sea. So much for stupidity. Meanwhile.... Tundra Disappearing At Rapid RateDate - March 7, 2007 ---------------------
Show full article (2.56Kb) · Show article thread
    

Group: sci.physics · Group Profile · Search for Ratedness in sci.physics
Author: Vendicar Decarian
Date: Mar 24, 2007 17:47

Show full article (3.48Kb)
    

Group: sci.physics · Group Profile · Search for Ratedness in sci.physics
Author: Vendicar Decarian
Date: Mar 23, 2007 11:52

Show full article (3.61Kb)
    

Group: alt.society.liberalism · Group Profile · Search for Ratedness in alt.society.liberalism
Author: Night of the Living Crackpots
Date: Mar 21, 2007 13:13

Show full article (0.79Kb)
    

Group: talk.politics.misc · Group Profile · Search for Ratedness in talk.politics.misc
Author: Night of the Living Crackpots
Date: Mar 21, 2007 13:13

Show full article (0.79Kb)
    

Group: can.politics · Group Profile · Search for Ratedness in can.politics
Author: Night of the Living Crackpots
Date: Mar 21, 2007 13:13

Show full article (0.79Kb)
1 · 2 · 3 · 4 · 5 · next