help with table / query

[nahum abramovich]

hi everyone


I appreciate your assistance.


I have 5 fields in the table:


First Field - Colors
Second Field - Shapes
Third Field - Number
Fourth Field - name
Fifth Field - Record date (When I save the form...).

NOW...



in my table it is possible that we get several same records with the same shape and number and color values. (not for the name and not for the date).


I want to add a field to my table (or other solution)
Where I will only see the last record update (by date) with the same color shape name values .

nahum

[nahum abramovich]

I appreciate your assistance.


I have 5 fields in the table:


First Field - Colors
Second Field - Shapes
Third Field - Number
Fourth Field - name
Fifth Field - Record date (When I save the form...).

NOW...

in my table it is possible that we get several same records with the same shape and number and color values. (not for the name and not for the date).


I want to add a field to my table (or other solution)
Where I will only see the last record update (by date) with the same color shape number values .

nahum

[CJ_London]

always better to provide example data and the outcome required as your description is unclear

you say

we get several same records with the same shape and number and color values. (not for the name and not for the date).

and

I will only see the last record update (by date) with the same color shape name values .

assuming your first description is correct, the usual way to do this would be to create an aggregate query (group by) grouping on color, shape and number and max record date

then link this to your table on the four fields

[nahum abramovich]

HI

thanks for your help!

i need guidance for making text box or label appear (on form) when 4 condition (from query) is met - This is just for showing a sign that pops up (doesn't have to be text inside).

i tried to do this with c

[COLOR=var(--ytd-video-primary-info-renderer-title-color, var(--yt-spec-text-primary))]onditional Formatting but[/COLOR]

my knowledge of Access is not so good...
[B]i tried something like this.....(inside expression builder)....iif( [q]! [a]= "Danny" And [q]! = "Triangular" And [q]! [c] = "Red" And [q]! [d] > "1", "ATTENTION" , " " )

i tried to do this also in label/text box control source .....
And that's probably not the way to do it ...


Would appreciate help

[CJ_London]

take a look at your post - can you read it, I can't? Forget the text formatting and use the button options for quote and code. For data, go to the advanced editor and select the table option for tables, (bottom row on left)

[nahum abramovich]

[B]hope that now is ok.....

thanks for your help!

i need guidance for making text box or label appear (on form) when 4 condition (from query) is met - This is just for showing a sign that pops up (doesn't have to be text inside).

i tried to do this with conditional Formatting but my knowledge of Access is not so good...


i tried something like this.....(inside expression builder)....

iif( [q]! [a]= "Danny" And [q]! = "Triangular" And [q]! [c] = "Red" And [q]! [d] > "1", "ATTENTION" , " " )

i tried to do this also in label/text box control source .....


And that's probably not the way to do it ...

Would appreciate help

[nahum abramovich]

Sorry. I didn't understand what I needed to do.

Please more detail

[CJ_London]

instead of this

conditional Formatting but my knowledge of Access is not so good...


i tried something like this.....(inside expression builder)....

iif( [q]! [a]= "Danny" And [q]! = "Triangular" And [q]! [c] = "Red" And [q]! [d] > "1", "ATTENTION" , " " )

i tried to do this also in label/text box control source .....


And that's probably not the way to do it ...

Would appreciate help

all you need is this

conditional Formatting but my knowledge of Access is not so good...


i tried something like this.....(inside expression builder)....

iif( [q]! [a]= "Danny" And [q]! = "Triangular" And [q]! [c] = "Red" And [q]! [d] > "1", "ATTENTION" , " " )

i tried to do this also in label/text box control source .....


And that's probably not the way to do it ...

Would appreciate help

only use bold or underline to emphasise a particular word or phrase - otherwise it is just 'shouting' and puts people off

first - you cannot conditionally format a label.

second - you appear to have spaces (in red), missing a field in (in blue) and treating a number as text (in pink)

iif( [q]! [a]= "Danny" And [q]! = "Triangular" And [q]! [c] = "Red" And [q]! [d] > "1", "ATTENTION" , " " )

you also need to explain where this code is - is it in a controlsource? conditional formatting? vba?

[simonjoe]

[B]hope that now is ok.....

thanks for your help!

i need guidance for making text box or label appear (on form) when 4 condition (from query) is met - This is just for showing a sign that pops up (doesn't have to be text inside).

i tried to do this with conditional Formatting but my knowledge of Access is not so good...


i tried something like this.....(inside expression builder)....

iif( [q]! [a]= "Danny" And [q]! = "Triangular" And [q]! [c] = "Red" And [q]! [d] > "1", "ATTENTION" , " " )

i tried to do this also in label/text box control source .....


And that's probably not the way to do it ...

Would appreciate help

Thanks mate

[CJ_London]

not sure what you are doing with your post (looks like you are trying to add your own formatting codes) but it makes it difficult to read - I was using the quotes to differentiate what you have compared with all that you need

you have not provided the information requested

you also need to explain where this code is - is it in a controlsource? conditional formatting? vba?

nor have you addressed these issues

second - you appear to have spaces (in red), missing a field in (in blue) and treating a number as text (in pink)

iif( [q]! [a]= "Danny" And [q]! = "Triangular" And [q]! [c] = "Red" And [q]! [d] > "1", "ATTENTION" , " " )

We cannot move forward until you have addressed both of these

[nahum abramovich]

ok from the beginning.

i need some TEXT to appear when 4 condition (from query) is met

i want the TEXT to appear on my form

bellow is what i tried to put inside text box control source.

iif([q]![a]="Danny" And [q]![b]="Triangular" And [q]![c]="Red" And [q]![d]>1, "ATTENTION","")the result - #Name? inside text box

I thought when its true - i will see on my form the word ATTENTION
and when its false ill see nothing.

[nahum abramovich]

ok from the beginning.

i need some TEXT to appear when 4 condition (from query) is met

i want the TEXT to appear on my form

bellow is what i tried to put inside text box control source.

iif([q]![a]="Danny" And [q]![b]="Triangular" And [q]![c]="Red" And [q]![d]>1, "ATTENTION","")the result - #Name? inside text box

I thought when its true - i will see on my form the word ATTENTION
and when its false ill see nothing.

[nahum abramovich]

ok from the beginning.

i need some TEXT to appear when 4 condition (from query) is met

i want the TEXT to appear on my form

bellow is what i tried to put inside text box control source.
iif([q]![a]="Danny" And [q]![b]="Triangular" And [q]![c]="Red" And [q]![d]>1, "ATTENTION","")the result - #Name? inside text box

I thought when its true - i will see on my form the word ATTENTION
and when its false ill see nothing.

[CarlettoFed]

Attach a sample file to understand what you've done and then help you

[CJ_London]

try

=iif([a]="Danny" And [b]="Triangular" And [c]="Red" And [d]>1, "ATTENTION","")