Distribute Row Information To Columns
Jun 18, 2012
I have a Query with many part numbers in column A and their inventory location(s) listed in column B. However, some part numbers are listed 2 or 3 times because the item is located in multiple inventory locations. How can I take these items and put list their inventory locations in multiple columns across one row?
What I have:
ITEM# Quantity INVENTORYLOCATION
A1 5 Warehouse 1
A2 3 Warehouse 1
A2 6 Warehouse 2
A3 2 Warehouse 1
What I want:
ITEM# INVENTORYLOCATION Quantity 1 INVENTORYLOCATION 2 Quantity 2
A1 Warehouse 1 5
A2 Warehouse 1 3 Warehouse 2 6
A3 Warehouse 1 2
View Replies
ADVERTISEMENT
Sep 25, 2013
i want to display a single field values in list box with query as row source.the query will produce variable number of records or rows. sometime 1, sometimes 3 or 6 my thought is to distribute these records/row into list box column. for example:
if query = 1 then listbox column = 1
if query = 6 then listbox column = 3 (two rows per column).
View 1 Replies
View Related
Jul 23, 2015
So i have a access database with a main field that we can call vendor # (LIFNR) and another called Company code (BUKRS). There are multiple company codes under a single vendor #. Example:
LIFNR
BUKRS
0000010535
1010
0000010535
5060
0000010535
5610
0000010536
1010
0000010536
5060
0000010536
5610
What I am trying to do is create a 3rd column where i can have a unique row for each of these fields without it repeating. There is no unique identifier in this table and that is what i am trying to achieve.
View 3 Replies
View Related
Jul 7, 2005
I have developed a db (A2K) which will be distibuted through our companies franchising system to various licensees. These licensees generally operate in a single PC environment but occasionally they will be based on a server network. The single user is fine but I am stumped by the server situation as it impacts on the various links I have set up within the database to files etc that are part of the program but are external such as Excel, Word files. The current links are all set up as C:MainFolderNameFilename. Of course these all stop working when I place it on a server and link the users up via shortcuts. On our own installation I changed the links to the \MyServerMainFolderNameFilename format and everythings fine but due to the number of links this is a fairly lengthy process and I wouldn't want to have to repeat it at every clients installation.
Can any one please advise me if there is a way to set it up so that I could say enter the clients server name in a field. Then insert that field's contents into the pathway details for the links so that they all update automatically.
Your assistance would be greatly appreciated.
View 4 Replies
View Related
Jan 3, 2006
Hi, I have a large database containing information that people all over the country want to access. I've designed a main form that contains 3 subforms that queries information from raw data. Now that the database is complete, i'm looking for the best way to distribute it. I've tried to put it on the network drive, but it has been rediculoursly slow. Could somebody tell me what would be the best way to do this? Thanks!
View 1 Replies
View Related
Sep 6, 2007
Hi,
I want to distribute an Access database to users, some of whom may not have Access installed on their computers.
The database has been developed using Access 2003 and I was wondering how I can distribute the database as a runtime version to my users.
Any help will be much appreciated.
Thanks,
Harmonic
View 9 Replies
View Related
May 26, 2006
I created the database on my computer. I added security and split the database to put the tables on the the server. Everything works just fine on my computer. However, when I try to copy the 3 files for the front end of the database to other computers on the network, it won't work.
Perhaps I'm confused as to what files need to be migrated to each additional computer or I don't have the security setup properly.
Right now, I move 3 files. The main database file with the front end. The shortcut file that is created when you add security and the security file that is created when you add security to the database.
I'm stumped.
View 4 Replies
View Related
Jan 12, 2008
Hi
Does anyone have a good easy sugestion on how to distribute a db with access runtime in a package to users without access 2003?
I have tried setup2go and it makes a fine .exe file.
But I can't make the package with access runtime.
Thanks
Mikael
View 1 Replies
View Related
Jul 27, 2007
Hello,
I have finally completed my database project. It is a split database. Back End on a network server.
I want to distribute the front end to all users however I want to limit to the best I can what they can do to it. Can someone please advise me on the best way to wrap up and send out my front ends?
All security has been established. I am talking about the availability to see the tables, macros, control bars etc..
Any suggestions would be greatly appreciated.
Fen How
View 1 Replies
View Related
Dec 28, 2007
All -
I have just about finished up a Split DB that I plan on deploying in a LAN environment. The goal of course is to turn what looks like an Access Application now into a non-access looking application where the Front End can be distributed and run on any computer within the LAN.
I have several questions that I may need some help on.
How does one go about hiding the Access Shell and/or Ribbon/Nav in 2007?
How would I add a form that allows for a user to navigate to and connect to the back-end without having them check all of the appropiate tables and then browse to the back-end file if they have a different drive letter mapped to the location of the back-end files for example?
Any tips on how to sign the DB so the pesky Trust Center question can be bypassed?
Any other tips on how to simply distribute this for a LAN environment and/or make it look NOT like an Access DB with access to view the Forms, Tables, Queries, etc. This is my first Access DB project, let alone a LAN distributable one.
Thanks!
View 7 Replies
View Related
Apr 18, 2015
I have a list that shows how many books we have for each PO No. (Sorted by PO No.) Like below:
LIST 1:
Code:
PO NoTOTAL BOOKS
PO-0001 12
PO-0002 15
PO-0003 26
Now I would like to distribute/divide these different books to boxes and each box gets maximum 10 books. Like below list:
LIST 2:
Code:
BOX NOBOOKSPO NO
0001 BOOK 1~10 PO-0001
0002 BOOK 11~12 PO-0001
0002 BOOK 1~8 PO-0002
0003 BOOK 9~15 PO-0002
0003 BOOK 1~3 PO-0003
0004 BOOK 4~13 PO-0003
0005 BOOK 14~23 PO-0003
Format is not important in the list2, for example in Box 0002 we have book 11~12 means (book 11 of 12 +book 12 of 12) in po-0001
+ book 1 of 15 until book 8 of 15) in po-0002
books have bookno, for example for po-0001 we have 12 different books it means we have bookno (1 of 12) until (12 of 12) for this po no.
How I can produce automatically list 2 from list 1 by query or coding.
View 2 Replies
View Related
Jul 31, 2013
I have multiple databases (Front-end, Back-end, Import, Reporting) which enables auditors in our company to audit loans.
I use an Import database which imports a random sample of loans (10%) into the Back End database for audit. I import a spreadsheet of loans (let's say 5000 loans) into the Import database, and I have the query return 10% of the loans, which is then imported into our Back-end database for audit (500 loans for audit).
Currently the auditors look at the daily list of loans (the 500 imported loans) and divide the work amongst themselves (5 auditors will audit 100 loans each.) They decide Bob will do 1-100; Joe will do 101-200; Bill will do 201-300; etc.
Is there a way using a query to assign these loans to specific auditors when importing the loans into the BE for audit? I would need to enter how many auditors will be working the loans so the work is divided evenly, and then enter the auditor's initials. (Since the auditors perform different audits, I would like the ability to select or key in auditor initials when importing the loans..
View 6 Replies
View Related
Jan 17, 2013
Is it possible to distribute updates from the frontend to an access runtime version?
View 1 Replies
View Related
Aug 17, 2015
Looking for efficient table structure for this. Let's say I have a list of contractors who will get paid a certain amount of money each week. The amount of money changes each week by measuring the amount of work done, giving it a price and calculating it. The fields are these:
[pk]WeeklyWorkID
WorkID
Quantity
UnitPrice
Total=Qty*UnitPrice (not stored in this table)
EmployeeID
WeekID
So far, it's all good, but we wish to pay the contractors in an unusual way. Let's say he makes $16,000 of work this week, and we want to pay him using cash AND/OR either one or multiple debit cards. For example:
Cash: $1,500
Debit card 45: $7,500
Debit card 71: $4,000
Debit card 13: $3,000
Total = $ 16,000
We can only deposit $7,500 max in each card. But it's even worse... two or more contractors can SHARE the card and it's not always the same card. Sounds pretty funky, but it's what the company wants to do. So, what would you recommend me in this case?
I'm guessing I'm gonna need these tables: tbWeeks to hold the week number, tbCards to store the cards' info, and an extra table to make a many to many relationship between the cards and the employees.
View 2 Replies
View Related
Aug 8, 2013
I was able to use the UNION ALL qry. But, when I have another file (like original2) that does NOT have all the columns listed in the UNION ALL qry, I get a Parameter value box asking for the missing columns when I run the qry.
Example:
original1IDDateGroupChristianJohnnySteve 18/5/2013A1528/5/2013B338/5/2013C2348/5/2013D2358/5/2013E5
original 2IDDateGroupChristianJohnny18/6/2013A212528/6/2013B2338/6/2013C2248/6/2013D22
The UNION ALL qry includes all the possible resources ( includes all the possible column fields Christan, Johnny, and Steve).
When I run the UNION ALL qry with the original2 file, An "Enter Parameter Value" box is displayed with the mssing column name "Steve".
Is there a way to Map the original2 table into a working table with all the columns, or use VBA code to construct the UNION ALL qry to only include the existing columns? My data has variable columns and I'm trying to avoid the parameter popups.
View 2 Replies
View Related
Jan 30, 2014
In my table for duplicate "line no" I have different "contractor" like below.
LINE NO CONTRACTOR
L-0001 C-1000
L-0001 C-2000
L-0003 C-6000
L-0003 C-8000
L-0003 C-9000
L-0004 C-5000
Now I would like to make a query for transposing values like below:
LINE NO CONTRACTOR1 CONTRACTOR2 CONTRACTOR3
L-0001 C-1000 C-2000
L-0003 C-6000 C-8000 C-9000
L-0004 C-5000
how I have to make this query?
View 1 Replies
View Related
May 14, 2014
I have a MS ACCESS 2010 database with a data table which i am trying to create a query from. I have 6 columns of data( one with an ID Field and 5 Name Fields). Below i have made examples of how it first appears as a simple query and the second will show you what i would like it to look like.
What the simple query looks like: [URL] ...
Second what I want the query to look like: [URL] ....
View 2 Replies
View Related
Oct 30, 2007
Currently I'm building tables and forms. My first table (called Clients) lists the details of fictional clients. My second table is for invoices.
In my invoices table, I wish to link the column for client reference (note: stored in the Clients table) to the column that precedes it. This column will list the clients’ names and is selected from a drop down list that is linked to the Clients table.
What I want to do (if its possible) is to have the respective client ref. automatically show up in the next cell once I've selected the client to whom the invoice relates?
Am I making sense? Is that possible? If so, how do I do it?
Secondly, how do I do a sum of selected columns for my “totals” column? Basically, I want to add the figures found in several cells that precede it?
View 4 Replies
View Related
Mar 22, 2007
I'm affraid my confusing topic title is an indicator of how confused I am by this. I can't even understand the variables well enough to fully utilize Access Help or the Search function here...
What I have is a database hat has column headers that look something like this:
Customer_Name, Order_Date, Qty_Ord, Unit_Price, Total_Price
What I'm trying to get is a query output that will have
Customer_Name, Total Orders (in Dollars) for January, Total Orders (in Dollars) for February, Total Orders (in Dollars) for March, etc.
I've been able to set it up to SUM for one month, but not multiples.
I know I'm totally lame (for proof read any of my previous posts) but you guys totally bailed me out the other time I asked a lame question.
Thanks in advance!
View 3 Replies
View Related
Jul 31, 2013
I am trying to convert a table that looks like the following...
Customer Name SumofSum of Bill Rate Reviewer
000462 John 500 Mike
000224 Mike 900 Jeff
I would like to covert it to....
Customer 000462 000224
Name John Bill
SumOfSum.. 500 900
Reviewer Mike Jeff
I don't think Access has any functions for this but I am not 100% sure. I know this can be done in a Module but I am not sure of how to code it.
View 12 Replies
View Related
Jan 4, 2006
I wonder if anyone has a quick fix for me. I have two tables in a project management DB that I am making. The first table is a projects table and the second is a tasks table. I would like to have a list box in the projects table containing all the tasks completed for the specific project. However, the current list box is showing all tasks rather than the ones specific to the project ID. The project ID is the primary key in the projects table and the foreign key in the tasks table. I am not sure if/how setting up a filter would correct this or if I just need to adjust the relationships. An example of the DB is avaiable if helpful.
Any advice or ideas would be greatly appreciated.
View 1 Replies
View Related
Jul 12, 2006
I have a client who wants his Accs db converted to MySQL. I have no problem understanding MySQL. However, my knowledge is limited with Accs.
This db is quite large (53mb) and has several tables, queries, reports, forms, modules, etc. I suppose he tried to create a backup and sent it to me. The problem is that all I have are the tables...nothing else.
Did he do something wrong or is that standard w/ Accs? Is there anyway I could have all of the information saved to some type of txt or .doc file and send that to me? I understand that would make it larger. The problem is right now Im on his computer (networking) and it's running too slow. I'm having to make screenshots and what-not (and that's when his secretary ISN'T WORKING...so pretty much at night). Really need some suggestions with this.
Thanx,
Tim
View 2 Replies
View Related
Jun 14, 2005
I am brand new to Access(I started yesterday). I have a ListBox that gets its selections from a Query. I set it for MultiSelect, and now I have to figure out how to store the selections. The list is organized in accending order, which does not match the table that the Query is based on. I have no experience with VBA. The form name is Trouble_Ticket and the ListBox name is List24.
Thank you
View 1 Replies
View Related
Jul 4, 2006
I have got a set of information that has a mixed bag of names. Some have only a first name but some have a middle name also.
I am looking to shortern the information just to the firstname (i.e. in stead of the results showing "Bill William" as the firstname, i want to just show "Bill").
i tried using the Left function but because the strings are of varied length i need the cut off to be the space between the various names.
Any help would be much appreciated.
View 4 Replies
View Related
Dec 27, 2006
I seem to remember - way back in my access class that I have not used regularly, therefore have forgotten much - that there is a way to put a description of the query or form or table that pops up in a kind of box when the cursor is placed over the name. I hope that makes sense - if not, read on.
I have a lot of queries and would want anyone using them to know what they will do before they click on one - because it might mess things up.
Thanks in advance,
Peg
View 7 Replies
View Related
Feb 8, 2007
I am having a hard time linking some certain information. I think I have my relationships formatted correctly but not all the information is connecting.
For example: I have a form where I am creating a sales quote. In the form I have a combo box where I select my product ID. When I select the product ID, the product name automatically populates but the price does not.
I have attached a screenshot of my relationships. Can someone please look it over and see if anything stands out to you as being incorrectly formatted? Or offer any advise in getting my price to connect to the product ID I enter?
View 14 Replies
View Related
