Result I get which I don't want What I want is the last table
Order2.OrderQty Order2.Company Order# Order1.OrderQty Order1.Company 3 abc AAA 3 abc 3 abc AAA 12 abc 7 Oop BBS 8 Oop 12 abc AAA 3 abc 12 abc AAA 12 abc
I am trying to count the number of times a client has engaged with our company. I have a company table, a reservation table, a rapid prototyping table and a project table. There is a one to many from the company table to each of the other 3 tables as can be seen in the attached picture.
Is there an easy way, in a single query, to list unique company names that exist in 1 or all of the 3 tables?
I'm building a database for my company who refurbish computers. I'm wanting to build in functionality for if a hard drive is damaged and it has to be replaced then for us to be able to trace (based on asset and tracking numbers) what hard drive has been removed from a PC and if it has been put into stock or destroyed and if a stock drive has been put into a PC.
Any item that is brought in whether it be a PC, laptop, server or hard drive etc is given it's own unique tracking number. Same is true for any stock we buy in for refurb purposes.
I'm thinking that this will be done by having a field for the original asset number and a field for the 'current' asset I.E. the one it's been put into.
I am trying to make a database that will keep track of invoice backlogs for different locations within a company.
Each day a report file is imported into an Access database (2010), and a query will display all locations with the backlog count of invoices for each of them. Something like:
Code: Location Backlog 00001 84 00002 53 00003 26
Now I would like to be able to store historical data in a new table on a daily basis so that it will be possible to see how the backlogs have fluctuated over time for a given location, but I am not sure how I could do this. I was thinking I could make a table with one row for every date and one column for every location, but then I am not sure how I would populate this table based on the query that shows the results based on the most recently imported report file.
The charity that I volunteer at has a web site through which they receive donations.
Most of the COMPANY names that they receive through their website are JUNK.
I would like to have a system to delete duplicate company names:
A = first programmatically delete all company names that are GOOGLE and this will remove about 60% of their spam B = next group all Duplicate Company names, which will be removed manually
How to get this one to display in a single column.
I know how to do this wiht VBA. But, this output will need to reside on a SQL Server View. So I need a SQL language solution. If it can work in MS Access Query, it won't be too difficult to test then translate to SQL Server.
Customer Table with PK Customer_ID.
There are two tables with FK Customer_ID.
1. Table Lease1 - Has 3 Fields - the form code enforces No Fields -or All Fields. The red * indicate a Required field - These 3 are entered together.
2. Table Lease2 - Has 1 field with 0 to Many records.
Goal:
The Type shows up in a single column.
Each Type shows where the data comes from (Lease Type, Surface Owner, Mineral Owner, or Hz Lease Type)
Challenge:
Lease1 table has 3 fields that need to be transformed into a single column.
Lease2 table has 1 field to be appended to the single table.
Then, there is the column that identifies where the data came from based on the column name.
I am trying to run a simple update query to copy data from one column (Addrl1)to another column (Working_Addrl1) within the same file and I can't for the life of me figure it out. Then I need to repeat for addrl2 and addrl3 to working_addrl2 and working_addrl3.
I have created a cross tab to extract pipeline and sales for Q1 2014, Q2 2014, Q3 2014 & Q4 2014... the user can select the quater from a multivalued text box...
Now for the final output, have created another query which pull the above four quarter in each column from the cross tab...now the problem arises when i change the quarter to Q2 2014, Q3 2014, Q4 2014 & Q1 2014..it gives an error "Microsoft office Access database does not recognizes "Query name" as a valid field name or expression".
The error is because the second layer of query does not identifies Q1 2014.
How do i make access change the column automatically when the Q1 changes to Q2...
i have a columns as 1. contactname, 2. firstname 3. lastname 4. email and in this columns some emails are not matching with the contactname or some time firstname or some time lastname so i need the to find out the un matched contacts from the database.
I am looking to add a column in a query that will give a Y or No to previous column data if it contains TEXT or NUMBER (It could read "TEXT" or "NUMBER" or even Y for text or N for number).
i would like to sum all the column fields in a tables column where an id is the same as the id in that table. I know you can use the SUM function in the select statement of your query.
But how can i set this sum result into a variable, so i can use it for calculation further on in the program?
My company rents equipment to our customers. I am looking for a db to track our stuff. There are three possible locations of everything. Warehouse, employee trucks, and Customers. I assume that warehouse can be added to the employee table. I can set up these 2 tables and one for our equipment list, but the hardest thing I am having with is with the table for transactions(I believe it should be a table), this needs to allow batch transations, because typically more than one piece of equipment is moved at a time.
I will need a report that will show each equipment id number in a customers home from date to date (date it was placed and date it was removed), one that will show a list of all equipment locations on a given date, and one more that will show equipment that has been in a customers house for 5 days or more so I can verify that it is still there, becuase equipment typically should never be with a customer for more than 5 days.
Right now I am using excel, but its not working well. I would greatly appreciate some help! The attachment only has the info I need for the 3 tables I mentioned above that I know how to do, and my best guess at what the transaction table should look like.
I have a database that controls donations for a Charity. There is to be a sister charity added to the database and a lot of the previously created objects can be used to provide for the new Charity. My idea was to create a "company" ID and label the categories of the donations. I could then use this company ID to identify to whom the data captured belongs.
I have used the switchboard manager to enable navigation, in this I have a ONload event procedure that requests the Company ID (1 or 2). That's as far as I have got.
How would I get Switchboard to open each form (some being based on queries - a couple direct on the tables) and filter the data on the company ID?
If there is a better way, please enlighten me!! :)
Hello All, I've searched and searched and can't find anything but it might be because I'm not sure what to search for.
Here is what I'm trying to do. (I'm simplifying this to make it easier to discuss) I have a table that looks like this: Company Date Sales 1 5/5/07 $1,200.00 1 6/5/07 $4,200.00 1 7/5/07 $2,200.00 1 8/5/07 $4,300.00 2 5/5/07 $1,200.00 2 6/5/07 $4,200.00 2 7/5/07 $2,200.00 2 8/5/07 $9,200.00 2 9/5/07 $1,200.00
I need to run a query that grabs the last 3 months for each company.
So the correct output from the above table would be: Company Date Sales 1 6/5/07 $4,200.00 1 7/5/07 $2,200.00 1 8/5/07 $4,300.00 2 7/5/07 $2,200.00 2 8/5/07 $9,200.00 2 9/5/07 $1,200.00
Any help would be appreciated. I'm sure this has been asked in the past so even if you could help me with a keyword to search for, I would be greatful.
I need to create a database of the info of a few hundred companies. Each company (food producers) specializes in various product categories, not just one. This is my problem/question: each company entry should then have a possibility to have as many product categories as needed. How can I do this without using "free text" fields? The website user should obviously also be able to search the db - by clicking checkboxes with the categories maybe?
(+Also: When the admin user needs to add the info of a new company (with, say, 9 product types) into the database, what kind of an SQL clause I need to INSERT INTO the db? For example if the product categories where laid out as checkboxes, and the user would just click the ones he wants.)
i I have two queries.. What i'm hoping is to combine the result into one query but not in one column only but instead the result of the second query should be beside the first query.. The result of the second query should be added as a new column.
First Query
SELECT tbl_uSers.UserName, Count(tbl_rEceived_eMail.EntryID) AS eMailReceived FROM tbl_rEceived_eMail INNER JOIN tbl_uSers ON tbl_rEceived_eMail.UseriD = tbl_uSers.UseriD GROUP BY tbl_uSers.UserName;
Second Query
SELECT tbl_uSers.UserName, Count(tbl_rEceived_eMail.EntryID) AS eMailProcessed FROM tbl_rEceived_eMail INNER JOIN tbl_uSers ON tbl_rEceived_eMail.UseriD = tbl_uSers.UseriD GROUP BY tbl_uSers.UserName, tbl_rEceived_eMail.ProcessedYN HAVING (((tbl_rEceived_eMail.ProcessedYN)="Y"));
Through word of mouth I hear that you can creat a link that can go from Access and link to the personal company system. Is this true? If it is, is there a standard code to use?
I've been asked to come up with a method of tracking outbound calls for my company. This is a new job for me and I'm aiming to impress.. but I'm a touch out of my element so I'm not trying to reinvent the wheel here.
I've found this starting point: [URL] .....
But I'm having difficulty conforming it to function the way I need it to. Basically, I want the applet to
-store the employees name -store customer names that were called -a checkbox for whether or not an appointment was set -a textfield storing an appointment date/time [if applicable]
-four radiobuttons to select which area of the business the call pertains to
The employees would submit new values everyday, and ideally I would like the data to be accessible in a real time line graph.. I totally assumed this would have been done and redone before and that there would be a plethora of templates to choose from online, but for the most part my search has been fruitless and the only solid lead is the one posted above.
And retrieving all **Basecode** if column data length >6 and with numbers '96', '78','54','15' by this query
Code: SELECT tbl1.EID,tbl1.Description,tabl1.Basecode FROM tbl1 WHERE (((Len([Basecode]))>6)AND ((Left([Basecode],2))='15')) OR (((Len([Basecode]))>6) AND ((Left([Basecode],2))='54')) OR (((Len([Basecode]))>6) AND ((Left([Basecode],2))='78')) OR (((Len([Basecode]))>6) AND ((Left([Basecode],2))='96'));
How do i get other data which won't retrieve based on above queries, other than data mentioned on these queries like this
Code: SELECT tbl1.EID,tbl1.Description,tabl1.Basecode FROM tbl1 WHERE (IsNumeric(Left(Base,1)) AND Left(Base,1) Not In ("W","N")) AND NOT (((Len([Basecode]))>6)AND ((Left([Basecode],2))='15')) OR (((Len([Basecode]))>6) AND ((Left([Basecode],2))='54')) OR (((Len([Basecode]))>6) AND ((Left([Basecode],2))='78')) OR (((Len([Basecode]))>6) AND ((Left([Basecode],2))='96'));
In a contact management DB I want to be able to record the addresses of a number of contact people and braches of the same company. In other words, a company has several branches and I want to record their different street addresses. What settings do I need to specify in the field "CompanyName" or elsewhere?
Another question is how to set a Text box, especifically "CityName," so the name of the city fill out the text box when I start typing the first letter of the city name but without using a predefined list of city names.
