Hi there!
I need your help. I am new with Access and I have a problem.
I have created a query that counts the AppSizerPerUD for every User Drive (UserDriveID). Now I want to assign these values to the other query (UserDriveUsage) for every UserDriveID.
So I want to create a new column in the UserDriveUsage query that will contain the AppSizePerUD.
In this case in the first two rows must be 23.6, then one row 18.38, the third one 45,39 etc.
I need something like a VLOOKUP in Excel. I have tried DLOOKUP but probably I am not uisng it correctly.
Any help would be more than welcome. I have attached two jpegs that I think could help you.
Thanks!
Vangelis
I need your help. I am new with Access and I have a problem.
I have created a query that counts the AppSizerPerUD for every User Drive (UserDriveID). Now I want to assign these values to the other query (UserDriveUsage) for every UserDriveID.
So I want to create a new column in the UserDriveUsage query that will contain the AppSizePerUD.
In this case in the first two rows must be 23.6, then one row 18.38, the third one 45,39 etc.
I need something like a VLOOKUP in Excel. I have tried DLOOKUP but probably I am not uisng it correctly.
Any help would be more than welcome. I have attached two jpegs that I think could help you.
Thanks!
Vangelis