20020430
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 2402 articles for 0.315 sec
Thanks so much for your help Arvin! "Arvin Meyer [MVP]" wrote: > So first, you must decide on whether or not a city or county sales tax is > applicable. For instance here in Florida each county has a different State > Sales Tax and State Gasoline Tax. Assuming that's not a consideration, I'd > build a table for the recordset to call upon with the following fields: > > tblStateTax >     

Group: microsoft.public.access · Group Profile · Search for 20020430 in microsoft.public.access
Author: Cindy - Atlanta,GA
Date: Apr 24, 2008 11:53

So first, you must decide on whether or not a city or county sales tax is applicable. For instance here in Florida each county has a different State Sales Tax and State Gasoline Tax. Assuming that's not a consideration, I'd build a table for the recordset to call upon with the following fields: tblStateTax TaxID - Primary Key (Autonumber) State - Text TaxStart - Long TaxEnd - Long TaxRate
Show full article (4.50Kb) · Show article thread
Hi Arvin, Thanks for the response. I'm a novice with SQL and Access, so I don't really know where to begin with either the Select Case or the recordset functions. Can you give me an example? It's true that the dates are not set as "date" data types - they're long integers only because that's the format used in the data file I imported to Access. "Arvin Meyer [MVP]" wrote: > I'm     

Group: microsoft.public.access · Group Profile · Search for 20020430 in microsoft.public.access
Author: Arvin Meyer [MVP]
Date: Apr 22, 2008 13:59

I'm going to assume that your dates are not real date datatypes since the way you are formatting them is useless to SQL. I would probably build a function and call it in a query or as the controlsource of a textbox in a form or report. Either use a recordset to get the State data from a table, or just use a Select Case statement. Personally, I'd prefer the recordset because it is more
Show full article (4.19Kb) · Show article thread
Is there a way to accomplish this calculation in Access? I need to reference the state and the date to determine the percentage to apply to the calculation. For example, if the state is GA and the date is between 20030501 and 20040430 apply 4%%, if the state is GA and the date is between 20050501 and 20060430, apply 3.5%% etc. These are the formulas and states (I6 is the date being referenced     

Group: microsoft.public.access · Group Profile · Search for 20020430 in microsoft.public.access
Author: Cindy - Atlanta,GA
Date: Apr 22, 2008 11:43

OK folks, one last comments on this problem, SPOOFER. My cyberPal from another couple of grps, who is quite the PC wizard posted the following concerning how to find out who is doing this and from where. It is a rather long post, so sorry. I am also deleting most of the spoofers post in this: ==Javelin==>x View profile More options Jan 15, 8:59 pm Newsgroups: alt.online-service.webtv
Show full article (2.39Kb) · Show article thread
On Jan 15, 7:52 pm, mauget <max.m...@gmail.com> wrote: > On Jan 15, 4:25 pm, "==Javelin==>x" <Jave...@webtv.net> wrote: > > > (P.S.)....... > > > ........The person who is spoofing SK's Hotmail addy is posting from > > Seoul, South Korea. ....See their IP , and DNS info. copied below > > here. > > > xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx > > > IP Information for 219.240.36.173 > > IP Location     

Group: microsoft.public.access · Group Profile · Search for 20020430 in microsoft.public.access
Author: Arvin Meyer [MVP]
Date: Apr 22, 2008 07:51

On Jan 15, 4:25 pm, "==Javelin==>x" <Jave...@webtv.net> wrote: On Jan 15, 5:50 pm, "==Javelin==>x" <Jave...@webtv.net> wrote: On Jan 15, 6:31 am, *The_Fake*-Jazz_Azz <shka...@hotmail.com> wrote: On Mon, 14 Jan 2008 22:09:08 -0800 (PST), Jazz_Azz wrote: Now there is this Mazda Miata grp. that I go to. And I just came from there to see if there were anymore
Show full article (1.90Kb) · Show article thread
"==Javelin==>x" <Javelin@webtv.net> wrote in message news:6f1382f9-6393-4457-914a-165787fb4347@l32g2000hse.googlegroups.com... > On Jan 15, 5:50 pm, "==Javelin==>x" <Jave...@webtv.net> wrote: >> On Jan 15, 6:31 am, *The_Fake*-Jazz_Azz <shka...@hotmail.com> wrote: >> >> > On Mon, 14 Jan 2008 22:09:08 -0800 (PST), Jazz_Azz wrote: >> > > Now there is this Mazda Miata grp. that I go to. And I     

Group: microsoft.public.access · Group Profile · Search for 20020430 in microsoft.public.access
Author: Cindy - Atlanta,GA
Date: Apr 22, 2008 07:33

On Jan 15, 6:25 pm, "==Javelin==>x" <Jave...@webtv.net> wrote: On Jan 15, 5:50 pm, "==Javelin==>x" <Jave...@webtv.net> wrote: On Jan 15, 6:31 am, *The_Fake*-Jazz_Azz <shka...@hotmail.com> wrote: On Mon, 14 Jan 2008 22:09:08 -0800 (PST), Jazz_Azz wrote: Now there is this Mazda Miata grp. that I go to. And I just came from there to see if there were anymore responses
Show full article (1.14Kb)
    

Group: rec.autos.makers.mazda.miata · Group Profile · Search for 20020430 in rec.autos.makers.mazda.miata
Author: Jazz_Azz
Date: Jan 15, 2008 21:55

Show full article (5.28Kb) · Show article thread
    

Group: alt.onlineservice.webtv · Group Profile · Search for 20020430 in alt.onlineservice.webtv
Author: ==Javelin==>x
Date: Jan 15, 2008 20:06

Show full article (3.13Kb) · Show article thread
    

Group: alt.onlineservice.webtv · Group Profile · Search for 20020430 in alt.onlineservice.webtv
Author: mauget
Date: Jan 15, 2008 17:52

Show full article (4.63Kb) · Show article thread
    

Group: alt.onlineservice.webtv · Group Profile · Search for 20020430 in alt.onlineservice.webtv
Author: Phil
Date: Jan 15, 2008 17:31

Show full article (4.45Kb) · Show article thread
    

Group: alt.onlineservice.webtv · Group Profile · Search for 20020430 in alt.onlineservice.webtv
Author: ==Javelin==>x
Date: Jan 15, 2008 16:35

Show full article (4.49Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next