markdooler
Member
- Local time
- Today, 23:25
- Joined
- Nov 25, 2020
- Messages
- 58
Hi ALl
I have converted a spreadsheet i use to be a database as it is growing large and unmanageable in spreadsheet form.
The issue i have is some of the functionality i get from the spreadsheet i cant seem to replicate in the database.
This is probably largely down to my lack of knowledge in Access compared to Excel.
Here is my issue.
I have 1 table called "day sheet", there is a field here called WIP number and a check box/text box field called "complete?"
I have another table called RB5 that only has WIP number in it.
I download the WIP number data into the RB5 table on an adhoc basis.
Want i want to do is to get the Day sheet table, complete field to use the WIP number field, go and look at the RB5 table, WIP number field and tell me if it is there or not.
For reference i have these same sheets set up in excel and use =IF([@[Wip Number]]="","",IF([@[Wip there?]]=[@[Wip Number]],"No","Yes"))
So it looks at the WIP number on the current page, looks at the RB5 page an returns a "No" if it can find it and a "Yes" if it cannot find it. (Yes this is backwards for a reason).
Any ideas would be great.
Thanks
Mark
I have converted a spreadsheet i use to be a database as it is growing large and unmanageable in spreadsheet form.
The issue i have is some of the functionality i get from the spreadsheet i cant seem to replicate in the database.
This is probably largely down to my lack of knowledge in Access compared to Excel.
Here is my issue.
I have 1 table called "day sheet", there is a field here called WIP number and a check box/text box field called "complete?"
I have another table called RB5 that only has WIP number in it.
I download the WIP number data into the RB5 table on an adhoc basis.
Want i want to do is to get the Day sheet table, complete field to use the WIP number field, go and look at the RB5 table, WIP number field and tell me if it is there or not.
For reference i have these same sheets set up in excel and use =IF([@[Wip Number]]="","",IF([@[Wip there?]]=[@[Wip Number]],"No","Yes"))
So it looks at the WIP number on the current page, looks at the RB5 page an returns a "No" if it can find it and a "Yes" if it cannot find it. (Yes this is backwards for a reason).
Any ideas would be great.
Thanks
Mark