HAVE AN AICT EXAM, REALLLY NEED HELP WITH THIS ONE STEP GUYS ;_;

[Wkhan860]

The Chill Master

 

[My Name]

Me too .-.

no prob

 

[Rahma Abdelrahman]

For step 11 from this paper http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s09_qp_2.pdf
HOW do you enter this criteria:
for the flights either out of or into London during the
month of August 2010.
Here's a list of fields I included in the query, now what criteria do I enter for which field for step 11? ):
I have an exam in a day so i really need to know how to do this step ;_;
Nafis Daiyan dude tag anyone you know who might be able to help with this .-.

Rahma Abdelrahman

I never took AICT, sorry... =(

 

[Maryum7]

Hi
I dont take AICT but umm maybe this might help or not
Hope it helps

Uhm hey thanks but that solution was for the excel part, I needed help with the access part, that is, step 11 .-.

 

[Nafis Daiyan]

A sad day in the life of Maryum7. tch tch

 

[Nafis Daiyan]

ZKhanXZ was last seen:Viewing thread HAVE AN AICT EXAM, REALLLY NEED HELP WITH THIS ONE STEP GUYS ;_;, 11 minutes ago

 

[ZKhanXZ]

ZKhanXZ was last seen:Viewing thread HAVE AN AICT EXAM, REALLLY NEED HELP WITH THIS ONE STEP GUYS ;_;, 11 minutes ago

I haz only IG Level Experience. :3 Sorry Maryum7 , can't help.. :/

Voh sabh to theek hai... but why were you Stalking mee..? :3

 

[Nafis Daiyan]

I haz only IG Level Experience. :3 Sorry, can't help.. :/

Voh sabh to theek hai... but why were you Stalking mee..? :3

Because I can B\

 

[ZKhanXZ]

Because I can B\

Hmm.. Point. :3

 

[Aly Emran]

For step 11 from this paper http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s09_qp_2.pdf
HOW do you enter this criteria:
for the flights either out of or into London during the
month of August 2010.
Here's a list of fields I included in the query, now what criteria do I enter for which field for step 11? ):
I have an exam in a day so i really need to know how to do this step ;_;
Nafis Daiyan dude tag anyone you know who might be able to help with this .-.

Hey maryum how are u ?
Long time

Ok back to the topic:
I did this ppr last year and i forgot a lot of things but I might be able to help u out. I guess u got confused by the wording of the statement....
It says that enter all fields of "To" and "From" from both "Out" and "Home" tables( plz send me the screenshot of what is written in the records under these fields. I might not give u the correct ans until i see those screenshots)
Then add the criteria "London" for both To and From fields or enter "*London*"...
And add criteria of: >=#1/8/2010# and <=#31/8/2010# If the format is d/m/y. If the format u suggested in data type of date is m/d/y then switch the position of day and month in the above criteria.....
Hope I helped

Ps: it would be more helpful if u send me screen shots of the data types and the table(the design view and the normal view both so that i can judge the data and decide).... And a screenshot of the query

 

[The Chill Master]

For step 11 from this paper http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s09_qp_2.pdf
HOW do you enter this criteria:
for the flights either out of or into London during the
month of August 2010.
Here's a list of fields I included in the query, now what criteria do I enter for which field for step 11? ):
I have an exam in a day so i really need to know how to do this step ;_;
Nafis Daiyan dude tag anyone you know who might be able to help with this .-.

post the completed files mean the step step till before this soory but due to i have short time

 

[The Chill Master]

The Chill Master

thanx for the tag

 

[My Name]

Uhm hey thanks but that solution was for the excel part, I needed help with the access part, that is, step 11 .-.

oops ,_,sorry

 

[Maryum7]

Hey maryum how are u ?
Long time

Ok back to the topic:
I did this ppr last year and i forgot a lot of things but I might be able to help u out. I guess u got confused by the wording of the statement....
It says that enter all fields of "To" and "From" from both "Out" and "Home" tables( plz send me the screenshot of what is written in the records under these fields. I might not give u the correct ans until i see those screenshots)
Then add the criteria "London" for both To and From fields or enter "*London*"...
And add criteria of: >=#1/8/2010# and <=#31/8/2010# If the format is d/m/y. If the format u suggested in data type of date is m/d/y then switch the position of day and month in the above criteria.....
Hope I helped

Ps: it would be more helpful if u send me screen shots of the data types and the table(the design view and the normal view both so that i can judge the data and decide).... And a screenshot of the query

Hi there ^.^ I'm good how are you?
Thankss for the help bro :3
So here are the screenshots of the query's design view, now I get what criteria to enter, but I should enter that criteria under which fields? ):

 

[Maryum7]

A sad day in the life of Maryum7. tch tch

;_;

 

[Aly Emran]

Hi there ^.^ I'm good how are you?
Thankss for the help bro :3
So here are the screenshots of the query's design view, now I get what criteria to enter, but I should enter that criteria under which fields? ):

Add criteria of "*London*" in FROM field of OUT table and TO field of HOME table...
Add ">=#1/8/2010# and <=#31/8/2010#" (if the date format is d/m/yyyy) in ODate and HDate fields.... I guess this should help

 

[Maryum7]

Add criteria of "*London*" in FROM field of OUT table and TO field of HOME table...
Add ">=#1/8/2010# and <=#31/8/2010#" (if the date format is d/m/yyyy) in ODate and HDate fields.... I guess this should help

Thanks bro, hope this helps c: