L
Little Penny
I have an inventory database, which includes a table of over 1500 computers that is on a complex that has over 18 different buildings. Our domain
naming convention uses the building number in the computer name as to find the location of a specific computer. I'm have been trying to create a
form/report as to give me the breaking down of computers that need to be changed (ie operating system or cpu speed which would indicate haw many
computer need to be upgraded and/or replaced altogether) I want to break this down by building . So did a two count queries for each building. I open
up a new form in design view. Open up the properties of the form. Clicked to data tab and hit the button with 3 dot on Record source. I then imported
all 36 count queries. When I try to return to form I get a query too complex.
The reason for the queries on a form is because the project will take several months and as time goes by, I need the ability to check the progress of
the project
My question is what the best way to get the information on a form or even a repot.
If at all possible
Thanks
naming convention uses the building number in the computer name as to find the location of a specific computer. I'm have been trying to create a
form/report as to give me the breaking down of computers that need to be changed (ie operating system or cpu speed which would indicate haw many
computer need to be upgraded and/or replaced altogether) I want to break this down by building . So did a two count queries for each building. I open
up a new form in design view. Open up the properties of the form. Clicked to data tab and hit the button with 3 dot on Record source. I then imported
all 36 count queries. When I try to return to form I get a query too complex.
The reason for the queries on a form is because the project will take several months and as time goes by, I need the ability to check the progress of
the project
My question is what the best way to get the information on a form or even a repot.
If at all possible
Thanks