Get values from one query and assign them to another query

tabos23

Registered User.
Local time
Today, 18:11
Joined
Dec 18, 2014
Messages
14
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
 

Attachments

  • DB1.jpg
    DB1.jpg
    39.3 KB · Views: 80
  • DB2.jpg
    DB2.jpg
    36 KB · Views: 78
You have told us HOW you have done something or HOW you intend to do something.
But WHAT is it that you are trying to accomplish?
Can you describe to readers in 4 or 5 lines in plain English WHAT you are trying to achieve? No Access, no jargon, just simple English.
 
I want to assign the AppSizePerUD from the AppSizePerUD query to the corresponding UserDriveID in the UserDriveUsage query.
Sorry for my english. Is it clear now what I would like to do?
Thank you in advance.
 

Users who are viewing this thread

Back
Top Bottom