d2jsp
Log InRegister
d2jsp Forums > Off-Topic > General Chat > Homework Help > Anyone Here Familiar With Excel Or Access?
Add Reply New Topic New Poll
Member
Posts: 3,008
Joined: Feb 25 2014
Gold: 6,820.00
May 3 2015 12:23pm
I need someone to complete a sequence assignment for me. It is really simple, just following a list of steps but I cant for the life of me figure out where half of this stuff is.

PM me with what program you are familiar with and I can send you the file and you can let me know what you will charge for its completion.
Member
Posts: 4,849
Joined: Mar 11 2012
Gold: 500.69
May 3 2015 12:27pm
Excel
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
May 3 2015 12:34pm
post if you have a sql question, but im not interested in doing assignments.
Member
Posts: 3,008
Joined: Feb 25 2014
Gold: 6,820.00
May 3 2015 01:01pm
Quote (carteblanche @ May 3 2015 11:34am)
post if you have a sql question, but im not interested in doing assignments.


how do I make a relative reference. would that just be (example) c6 and an absolute reference is f4 or $c$6
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
May 3 2015 01:16pm
Quote (H3LL0K1TTY @ May 3 2015 03:01pm)
how do I make a relative reference. would that just be (example) c6 and an absolute reference is f4 or $c$6


i assume that's an excel question, not a sql question.

relative to what? if you want to shift the focus to the cell below when copying formulas, then c6 is relative. $c$6 is anchored. if you copy the formula down, then c7 will be used.
Member
Posts: 3,008
Joined: Feb 25 2014
Gold: 6,820.00
May 3 2015 05:34pm
in this example for access:
c. Add criteria so that only those records with a ClubName field value of Boy Scouts Troop 6 or those with a CenterName field value equal to Rolling Hills Trash are selected. (Hint: The records returned by the query will fulfill either criteria.)

How would I write the club name criteria and center name criteria so that is would allow me to search for records containing either or
Member
Posts: 32,925
Joined: Jul 23 2006
Gold: 3,804.50
May 3 2015 05:36pm
select * from sometable where ClubName = 'Boy Scouts Troop 6' or CenterName = 'Rolling Hills Trash'
Member
Posts: 3,008
Joined: Feb 25 2014
Gold: 6,820.00
May 3 2015 05:41pm
Quote (carteblanche @ May 3 2015 04:36pm)
select * from sometable where ClubName = 'Boy Scouts Troop 6' or CenterName = 'Rolling Hills Trash'


thank you, i was having a brain fart.. soo much homework... I didnt ut the second criteria in the or section so it didnt execute currectly.
Go Back To Homework Help Topic List
Add Reply New Topic New Poll