ICT : Post your doubts here !

[PhyZac]

Yeah it's not working... some technical problem...

i did da same thing but its not workin ????

hmm wait lemme check again !

 

[PhyZac]

VIN criteria -- Like "366C*" or Like "365C*"
Fuel criteria -- "4"
Dispatched criteria -- "No" ( should be No ) without the ""

 

[Yours Truly]

VIN criteria -- Like "366C*" or Like "365C*"
Fuel criteria -- "4"
Dispatched criteria -- "No" ( should be No ) without the ""

I know... i tried it a million times! But it ain't working =/

 

[PhyZac]

I know... i tried it a million times! But it ain't working =/

VIN and fuel working not the dispatched ryt ?

 

[Yours Truly]

VIN and fuel working not the dispatched ryt ?

Sometimes it's the damned fuel... otherwise it's dispatched

 

[PhyZac]

Sometimes it's the damned fuel... otherwise it's dispatched

haha,
see i tried now,
fuel was working but YES was appearing...i got fed up and deleted the YES leaving NO only !!! ( this wat i do wen i get stuck but i make sure i hv another original table to be able to do rest instruction ryt )

 

[Yours Truly]

haha,
see i tried now,
fuel was working but YES was appearing...i got fed up and deleted the YES leaving NO only !!! ( this wat i do wen i get stuck but i make sure i hv another original table to be able to do rest instruction ryt )

If i filter... it works... otherwise it just ain't working

 

[PhyZac]

If i filter... it works... otherwise it just ain't working

but wen i filter, it still willl appear in report !

 

[PhyZac]

If i filter... it works... otherwise it just ain't working

tell me ,
wen the say make sure all margin matchs the alignments ( i skip this instruction) wat does it mean??

 

[reina81]

In MJ 08 (paper 2) step 43 they asked us to show the records where the 'Notes' field is not blank. How do I do this?

 

[PhyZac]

In MJ 08 (paper 2) step 43 they asked us to show the records where the 'Notes' field is not blank. How do I do this?

in criteria write: <>""

 

[reina81]

In queries can someone explain when do we use 'like' * or 'Like' #

 

[PhyZac]

--> 10 tips for Access wildcardz <--​

Awesome site check it !!​

 

[reina81]

how do i do step 45 in paper2 of MJ 08. cant find the link on xtreme

 

[PhyZac]

how do i do step 45 in paper2 of MJ 08. cant find the link on xtreme

okay wait lemme check (btw link found in retired subjects in the CIE page )

 

[PhyZac]

how do i do step 45 in paper2 of MJ 08. cant find the link on xtreme

Do a normal query wizard,
in product criteria ryt: >3
tick only Stock Country, Product so tht only appear.
click RUN
then click query wizard and choose summary
then summary option
tick SUM for Stock
an
Wrong :/

 

[reina81]

Do a normal query wizard,
in product criteria ryt: >3
tick only Stock Country, Product so tht only appear.
click RUN
then click query wizard and choose summary
then summary option
tick SUM for Stock
and count..example in the pic
View attachment 7785

But the "Product" is a text field there aren't any numbers for it to be greater than three

 

[PhyZac]

But the "Product" is a text field there aren't any numbers for it to be greater than three

hmm, i dont really know,,,i mean is this the part of question?

 

[reina81]

yes that's it

 

[PhyZac]

So?? how can it be text.....i should the support file wait!