I have a table with the folowing structure:
ID(integer)
Value1(Double)
Value2(Double)
I need to split this table in 4 equals parts:
- count of id must be equal or close to equal(ex: 467 split in 3 x 117 and 116) for each part
- the cumulated Value1 and Value2 must be equal or close to equal for each part
I have a table with the folowing structure:
ID(integer)Value1(Double)Value2(Double)
I need to split this table in 4 equals parts:
- count of id must be equal or close to equal(ex: 467 split in 3 x 117 and 116) for each part
- the cumulated Value1 and Value2 must be equal or close to equal for each part
I am currently creating a form to input new return parts into a database. I am trying to automatically generate a tracking number (##-AA-####-####). I have gotten myself to generate the ##-AA-#### in a list box and almost was able to generate the sequence number, 0001, 0002, etc. using the dmax function. I would like to generate the sequence number one higher than the highest, depending on part type and last 4 digits of part number. Our parts have unique last 4 different p/n but more than one can fall under the same type.
View 14 Replies View RelatedWhats the best way to show the text result of a combo box selection when displaying the information through a query? I notice the table is also reflecting only the numerical ID result of the selection so I'm not sure how to take this result and display it as a text result to the user.
View 7 Replies View RelatedI have a table with an ID and PartNumber field.
Parts tbl
PartNumID PK(Auto)
PartNumber
Heres some example data:
1 M24308/2-2F
2 M24308/4-2F
3 ORD9F0000
4 ORD9M0000
5 D90000VLO
6 D90000JOO
How would I design the table to allow me to define alternatepart numbers and also related parts? For example:
Record 1 is the primary part and record 3 is the alternatepart.
Record 2 is the primary part and record 4 is the alternatepart.
Records 5 and 6 are related parts to records 1, 2, 3 and 4.
I have a form that allows the user to select a part and displaythe part data. But I also want the alternate parts and related parts displayedon the form, maybe in a subform with tabs. I havent gotten there yet because Icant determine the table design.
I have a report that is generated daily that is a TXT file that is also the has the same file name each morning. One section out of this file is needed in a database that compiles and sends out reports to our customers. This section of the TXT file is variable in length, but is always preceded and ends with a specific text string that I can search for. It is also formatted in columns that are always the same width.
I currently have to hand enter this section into the database every morning. Not the easiest of tasks... I would like to get this automated.
We use a lot of different pipes for our work for different projects, I have inputed some basic data into a table called item description, this conotains the pipe detail (diameter/type) supplier and length its supplied in.
What I want to do is create a form which we can populate with all the defferent types of pipe in one of our jobs. I want to create a form for adding new parts to the table so its more user friendly to other users as opposed to using the table itself.Also when we are listing down the different pipes and fitting within one of our jobs there may be a few duplicated for example there may be 3 90deg bends.
Can I create a report once the form has been populated with all the different items which groups the duplicates together and totals them up? Ideally the final report will list each different part, and the quantity/length required.
Access 2013. I have a table that I would like to contain columns from other tables when the form containing the table is loaded.
Example:
I open a form to input information into the table 'Equipment Input', but I want Equipment Input to be partially loaded with columns from another table 'Equipment and Rates.'
In a situation where I imported an excel file with so many columns and split them into two temp tables and they are linked using a key.
the data has a fixed part lets say
Field1....Field2.....Filed3.....Field4...then Field5.....Field6.....Field7....Field8 is the same data range as Field9...Field10...Field11...Field12. I would want to split this data into multiple rows like this
Field 1 Field2 Field3 Field4 Field5 Field6 Field7 Field8
Field 1 Field2 Field3 Field4 Field9 field10 field11 field12 and so own...
What is the best approach?
Hi Folks!
Need help! Is there a BCP equivalent in access. I want to load 2 million rows into an access database.
Any pointers will be of great help.
Thanks,
Moksha
What is equivalent for Last function in access to that in SQLserver
View 1 Replies View RelatedHi,
I have two access tables :
Table 1 : Customer number / E-mail
Table 2 : Customer number / Address / Phone
I like to add the data of table 1 to table 2 :
Customer number/ Address /Phone / E-mail
When of course the customer number is matching in both tables .
Can someone help me ?
Thanks
I need to use dlookup in a query to populate a new field "number" with values obtained using a current field "letter". I have a (lookup) table as follows: Col1 = A, B, C, D and Col2 = 1, 2, 3, 4 which of course gives the number code corresponding to each letter.
In Excel, I simply use the formula: vlookup("letter", "lookuptableref", 2, false) and it populates my new field number with the correct values.
Can anyone help me with the equivalent in Access using dlookup?
Thanks!
this is vexing me.
I have 4 tables, 2 entities, 1 relationship and 1 lookup
Entities are tblOrg and tblForm
Relationship is tblVentureParticipation
Lookup is tblInfo (Has many different lookups)
When an organization (these are listed in tblOrg) turns in a form, a new record is inserted into tblForm with the ID of that organization and the ID of the form
I want to identify the forms that have NOT been turned in.
So I figured
Step 1:
Identify all organizations who are participating (WHERE tblOrg.OrgID = tblVentureParticipation.OrgID)
Step 2:
Join all of the previously selected organizations with all of the forms (FROM tblOrg, tblInfo WHERE tblInfo.LookupID LIKE 'F##')
Step 3:
Remove all of the entries in tblForm that match the result of Step 2.
I have verified that both of these individual queries return the right information ...
Hi all,
Sorry for such a Newbie question but....
I'm trying to find the equivalent of Filemaker's Lookup function within Access. To quote the Filemaker help page:
"A lookup copies data from another table into a field in the current table. After data is copied, it becomes part of the current table (and remains in the table from which it was copied). Data copied to the current table doesn't change automatically when the data in the other table changes.
To establish a connection between tables for a lookup, you create a relationship. Then you define a lookup to copy data from a field in the related table into a field in the current table."
The requirement for this is for an invoicing database where we need to copy a customer's invoice and shipping address into the invoice record so that, if the customer changes address, the old orders retain the actual address that was shipped to rather than be updated to whatever the customer's current address is. The same applies to many other things that fluctuate over time such as promotion discounts and list prices. When these change, looking back through old orders will give different prices than were actually invoiced. This must be a very common situation.
I've searched high and low on the web for an answer but so far have come up with nothing. A workaround might be to create the relationship then, when the customer ID (or product code etc) is changed, fire off a macro that copies the data from the related fields in the second table into the appropriate fields within the current table. If the Filemaker Lookup functionality is already present within Access it would be much neater to use that instead.
Any ideas?
Many thanks,
- Andy
Hello all,
I am trying to improve the network performance of my database and I need to convert the DCOUNT function into a SQL statement.
my code
=DCount("[Queue]","qryODFQueueNBET")
The tables are stored in the backend.
I have about 30 of the DCOUNT functions and it is really slow when running in the network.
Thank you,
I have got a combo box with a product code in it, and depending on which code is selected I want the data to come from one of two different tables. Is there any way I can do something like a match formula in Excel to see if the stock code is contained in a table?
View 3 Replies View RelatedI am an intermediate level Access user and I am trying to have one of my tables lookup data in another table and populate the corresponding data. For example, TABLE 1 and TABLE 2 both have a common field, MATERIAL field. TABLE 1 contains a SERIAL CODE field which is all the serial codes and TABLE 2 does not. I am trying to copy over the serial codes for 1000s of lines of data from TABLE 1 to TABLE 2 via the corresponding MATERIAL field. How exactly can I do this? Please be specific and do not leave any steps out if I need to enter functions, etc. Please tell me exactly where the process needs to be implemented.
Thank you very much in advance.
Ease
I have one table - 40 fields, 40000 records. Iwant split this one table up to 4 different tables (keep data). Is there an easy way, pls?
View 6 Replies View RelatedI have a table which contain around 10 Lacs records, now i want to split the same in to 10 or more table with 1 lac records.
View 1 Replies View RelatedI'm gonna get right into it; here are two tables I have in my database.
tblAccession
-Accession (PK)
-State
-Test Type
tblSamples
-Accession (FK)
-Sample
-Additional
-Cassette
-Tissue Type
-Comments
-Trim initials
-Trim date
-Section initials
-Section Date
-Control (FK from a third table)
For tblSamples, the fields:Accession, Sample, Additional, Cassette is the same for each accession and is entered when an Accession is logged in at the beginning of the process. The rest of the information (Tissue Type, Comments, etc.) is entered when various people completes those steps throughout the testing (fluctuating people and days). Should I have have the fluctuating information (tissue type, comments, etc.) as a separate table? With a one-to-one relationship? Would there be an advantage/disadvantage to splitting tblSamples into two different tables?
i'm using a sql procedure which i'd like to implement the equivalent in ms access. i want to know if they can be any possibilities. this is my procedure
Code:
CREATE PROCEDURE CreateOrders
(@cartId char(36))
As
DECLARE @CmdID int
INSERT INTO Commande DEFAULT VALUES
SET @CmdID = @@IDENTITY
INSERT INTO DetailsCommande ( CmdID, ProduitID, ProduitTitre, Quantite, CoutUnitaire )
[code]...
How can I convert a date format to it's numerical equivalent inside of a query? For instance, 1/1/2014 to be 41640.
View 2 Replies View RelatedI am using a Table to store Parameter Values for a Split Multiuser DB. Question I have...Can I have this Table on the Front End while all the others are on th back end? The use for the table is to store parameter values for multiple queries without the user having to reenter the parameters.
I've tested this and it seems to work...but would like to know if there may be complications.
FYI. I am a Novice VBA user.
Thanks,
Felix
Hi all
I was hoping to get a little advice as to my problem. I have a database with many, many reports, forms and queries. I wanted to split the database to secure the tables and important data. So I use the database splitter wizard and ever thing went just fine. So now my database1 looks into database1_be for all tables.
My problem is: my program now runs very slow. The slowest seems to be when I am adding a new record. I can live with the slowness of retrieving an existing record. I do not have a server nor can I afford one at this time, so currently I am running a peer-to-peer network with the database1_be located on one of my computers second hard drive.
Is there something I can do to help speed things up?
Thanks Enviva
Hi there!
I'm currently working on a malformed Access database, not normalized at all.
It only consists of one table and is designed like this:
(table compartment)
#ID#Name#Member1#Member2#Member3#Member4#...#Membe r20#
So all the members are realized by single columns.
I created a new database, consisting of the main table, the "people" table and a relation table, connecting the people with the compartment (n:m relation).
It works great but I have to get the old data into the new tables. The old main table consists of more then 100 columns, and most of them are now hived off by using relations.
Now I'm looking for a smart solution to convert the table.
Do you have any idea? I tried to use a Query, but I couldn't merge two or more columns and put them in a single one on a new table.
Thank you in advance!