Author Topic: Access 2007 help  (Read 1559 times)

Offline Fkacn_tt

  • Global Moderator
  • Kage
  • *
  • Posts: 1500
  • Country: 00
  • Chakra 2
    • PS3,PsP, Dead PS2
  • Referrals: 1
    • View Profile
  • CPU: AMD Athlon 64 X2 4400+
  • GPU: XFX 4850 512mb
  • RAM: 2 GB PC 6400
  • Broadband: Flow
  • PSN: r_guy007
Access 2007 help
« on: April 07, 2009, 01:09:58 AM »
I'm try to create a query where, it adds related figures from fields on different rows for a certain individual and outputs the total in totals field.

Eg sale 1 for Tom Black + sale 2 For Tom Black = Total Sale for Tom Black

In the pic below i'm also looking to tweak the query where it onl show the CLID, NO. of sales(using a count of the amount of orders for that specific person), PID, FName, LName, Total.

I really appriciate any help and i know its late.
" border="0

Carigamers

Access 2007 help
« on: April 07, 2009, 01:09:58 AM »

Offline Fkacn_tt

  • Global Moderator
  • Kage
  • *
  • Posts: 1500
  • Country: 00
  • Chakra 2
    • PS3,PsP, Dead PS2
  • Referrals: 1
    • View Profile
  • CPU: AMD Athlon 64 X2 4400+
  • GPU: XFX 4850 512mb
  • RAM: 2 GB PC 6400
  • Broadband: Flow
  • PSN: r_guy007
Re: Access 2007 help
« Reply #1 on: April 07, 2009, 02:03:12 AM »
Figured it out, was very simple i'm kind of ashame for asking for help.
" border="0

Carigamers

Re: Access 2007 help
« Reply #1 on: April 07, 2009, 02:03:12 AM »

 


* ShoutBox

Refresh History
  • Crimson609: yea everything cool how are you?
    August 10, 2022, 07:26:15 AM
  • Pain_Killer: Good day, what's going on with you guys? Is everything Ok?
    February 21, 2021, 05:30:10 PM
  • Crimson609: BOOM covid-19
    August 15, 2020, 01:07:30 PM
  • Shinsoo: bwda 2020 shoutboxing. omg we are in the future and in the past at the same time!
    March 03, 2020, 06:42:47 AM
  • TriniXjin: Watch Black Clover Everyone!
    February 01, 2020, 06:30:00 PM
  • Crimson609: lol
    February 01, 2020, 05:05:53 PM
  • Skitz: So fellas how we go include listing for all dem parts for pc on we profile but doh have any place for motherboard?
    January 24, 2020, 09:11:33 PM
  • Crimson609: :ph34r:
    January 20, 2019, 09:23:28 PM
  • Crimson609: Big up ya whole slef
    January 20, 2019, 09:23:17 PM
  • protomanex: Gyul like Link
    January 20, 2019, 09:23:14 PM
  • protomanex: Man like Kitana
    January 20, 2019, 09:22:39 PM
  • protomanex: Man like Chappy
    January 20, 2019, 09:21:53 PM
  • protomanex: Gyul Like Minato
    January 20, 2019, 09:21:48 PM
  • protomanex: Gyul like XJin
    January 20, 2019, 09:19:53 PM
  • protomanex: Shout out to man like Crimson
    January 20, 2019, 09:19:44 PM
  • Crimson609: shout out to gyal like Corbie Gonta
    January 20, 2019, 09:19:06 PM
  • cold_187: Why allur don't make a discord or something?
    December 03, 2018, 06:17:38 PM
  • Red Paradox: https://www.twitch.tv/flippay1985 everyday from 6:00pm
    May 29, 2018, 09:40:09 AM
  • Red Paradox: anyone play EA Sports UFC 3.. Looking for a challenge. PSN: Flippay1985 :)
    May 09, 2018, 11:00:52 PM
  • cold_187: @TriniXjin not really, I may have something they need (ssd/ram/mb etc.), hence why I also said "trade" ;)
    February 05, 2018, 10:22:14 AM

SimplePortal 2.3.3 © 2008-2010, SimplePortal