Major newbie needing help

[Dragox]

I have a minor knowledge of excel and a very basic knowledge of access.



heres my problem,

The cell that my cursor is in should be False, then any cell below Should be true if the value of the cell next to it has changed from the value of the cell above the cell next to it.

i need it to display false or true based on that.

another example,

the top left is 2,
one below it is 3, meaning the box should display "true" to indicate that it has changed from the value before.
one below that is 3, meaning the box should display "false" to indicate that the value has not changed from the previous value.

I cannot work out how to use access, this has baffled me. Im so used to writing formula's in excel

any help would be apreciated :P

[TheShabz]

This shouldn't be done in access to begin with. Access isnt just Excel on steriods, they have different roles. Let's say you have that done, and you sort it in ascending order... then what? I'm not sure how Excel VBA does things but the logic you would want to use is to declare 2 variables, var1 and var2 for now. Your code will go through the F3 column, take the first one and assign it to var1. Then goes to the next row and assigns that to var2. you then run a check.
If var1 = var2 then
'the row of F4' = "True"
Else
'the row of F4' = "False
End If

Loop

[Dragox]

I knew this would be difficult in access, I have it in excel using =({current Cell}<>{Previous Cell})

I need the records i have in Excel imported into access, However, the formula's dont work in access, meaning i have to work out some magical way of allowing the database to have "excel like" functions

unfortunatly i have no knowledge of Vb

[TheShabz]

What you have there is meaningless in Access. What is going to be done with it in Access?

[Dragox]

Ive been asked to get the spreadsheet imported into access.

that pic i put is a snippit of one of the many .xls documents with 65k records each. Thats partly one of the reasons that it has to go into access.

All of the formula's are based of the exact same thing (checking if the values changed and displaying true/false to indicate if it has) so if i can get one to work then the should (hopefully) be easy.



saying that, access is starting to be a royal thorn in my side.

im used to telling an individual cell exactly what to do. The problem is, theres no way of doing that in access. And i havent got a scooby on how to get it to work anything liek what im used too.

[ConneXionLost]

You need to use a Primary key and add a false foreign key so that you can use a quasi self join to the foreign key.

For example:

PK	Value	FFK
0	2	1
1	3	2
2	3	3
3	3	4
4	3	5

In a query, link a self join from PK to FFK, then make the comparison between the values and record the result in a calculated field.

Cheers,