Split Form Input Into Multiply Rows

May 14, 2007

Hi, I have a problem, I want to split up form input into several rows but I don't know how. Alright here's the deal: I have a textbox in a form were I write down all the ipaddresses for one computer and all the addresses end up in the same row in the same field in the table, I want the addresses to end up in different rows but in the same field, how do I do?

I might also add that i'm pretty new to access.

View Replies


ADVERTISEMENT

How To Multiply Values In A Form

Mar 22, 2005

Hi. I'm new to Access and I wonder if someone could help me with this problem I am having while constructing a database. We need to create a database of reservations to a program we offer. We will need to store the quantity of reservations per person. What we needed to do is multiply the quantity of reservations by the value of each reservation and get a 3rd field with the final amount. So we need a field with the result of the multiplication of the quantity of reservations by the value of each reservation, which is a fixed amount. I'm having problems getting access to do this, I get an "error" message on the resulting field. Can somebody help me with this?

Thanks.

View 3 Replies View Related

How To Split Up One Column With Multiple Rows Related To One Person Into A Query

Jul 1, 2013

I have an Access Database and I want to split up one column into multiple columns. The one column has multiple rows that relate to one person, so for instance I have the following:I am taking information from both tables and I want to create a query but I need to separate out the mother, father, and guardian with the names attached

So from the Child table :

Joe Smith Address Phone

The query that I created is from two tables, the child table and the family table: ( I used the dashes just for it to be easier to read)

------Child Table/PrimaryKey --------Family Table---------------------

First Name--- Last Name--- First Name--- Last Name--- Relationship
Joe ----------------Smith ----------Jane --------Doe-------------Mother
Joe ----------------Smith ----------John---------Smith---------- Father

So in this scenario I need to get the name of the second parent in another column....meaning have all the parents appear on the same line for this child, and each child there after..

So I need it to look like this:

------Child Table/PrimaryKey --------Family Table---------------------

First Name------ Last Name------ First Name------ Last Name------ Relationship------ 2First Name------2Last Name------2Relationship
Joe----------------Smith------------ Jane-------------- Doe------------- Mother-----------John---------------- Smith------------ Father

View 1 Replies View Related

Queries :: Entries Separated By Commas - Split A Cell Into Multiple Rows

May 7, 2014

I'm a new to Access, SQL. I need the following output:

Input:

PHP Code:

PO              Vendor       State
a, b             1,2            IL
c, d, e          3              TX
f                  5              CA 

Output:

PHP Code:

PO          Vendor   State
a             1,2        IL
b             1,2        IL
c             3          TX
d             3          TX
e             3          TX
f              5          CA 

I found the following SQL code from another forum, which splits entries in a cell separated by commas into 2 rows, output being:

PHP Code:

PO          Vendor   State
a             1,2        IL
b             1,2        IL
c             3          TX
d,e          3          TX
f              5          CA 

SELECT * INTO ImportedData
FROM (
SELECT PO, Vendor, State
FROM SourceData

[Code] ....

How to run a loop so that if a cell has n entries separated by commas, I want them to be split into 'n' number of rows.

View 3 Replies View Related

Modules & VBA :: Split Table Record Into Multiple Records / Rows In A New Table

Nov 10, 2014

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?

View 3 Replies View Related

Calculated String Input Field In An Input Form.

Jan 30, 2005

Hello,

I need to create a field in an input form that is simply the concatenation of two other text fields. I have tried all sorts of things, but when I look at the data in the table that field.

I have a field called ID that I want to be created like this:

=Format([UniqueID],"00000") & "-" & [Mosque]

This works well in my output fields, but does not work the same way on the input form. It needs to be based on the currently input values from the current record. Anyone have any ideas?

Thanks in advance,
--Robert

View 3 Replies View Related

Multiply Fields

May 21, 2005

How to multiply a group of records in an Table (eg. I have a table with tow fields Id and Value, how to multiply all Value records)

View 1 Replies View Related

Multiply Queries

Sep 5, 2005

I am try to do all in one queries which has two queries imbedded into.

"SELECT Filter_ID, Channel, SpeedBands, Filter_Channel, Filter_type
FROM
(SELECT [Tbl_Lookup_Channels].[ID] AS Channel, [Tbl_Lookup_SpeedBand].[ID] AS SpeedBand
FROM Tbl_Lookup_Channels, Tbl_Lookup_SpeedBand)
LEFT JOIN
(SELECT [Site_ID] AS Filter_ID, [Channel] AS Filter_Channel, [Type] AS Filter_SpeedBand
FROM Tbl_SiteResults
WHERE Site_ID=" & ID &")
ON ((SpeedBand = Filter_Speedband) AND (Channel = Filter_Channel))
GROUP BY Filter_ID, Channel, SpeedBands, Filter_Channel, Filter_type
HAVING Filter_Channel Is Null AND Filter_type Is Null
ORDER BY Channel, SpeedBands;"

If is not work at all it is just asking that it is invalid join to the main query

Thanks

Sean

View 2 Replies View Related

Count And Multiply

Jun 15, 2006

Does anyone know how to count a field and multiply the answer automaticaly.. so if i have a count function on number of names repeated in a table via nameID the result would be presented in the new query with how many times name repeated multiplyed by a defualt set number.instead of name repleated 3 times, it be 30 times..using a query. any help appreciated..thanks

View 5 Replies View Related

Multiply Parameter Queries!

Apr 13, 2007

i have a Query where i have Criteria for two fields as the following:

Field :Date of Incident
Crirteria: [Forms]![frmSearchStudent&Date]![cboStartDate] And [Forms]![frmSearchStudent&Date]![cboEndDate]

Field: StudentSurname
Criteria: [Forms]![frmSearchStudent&Date]![Combo0]

Occasionally, staff may just want all incidents (records) to be shown for the selected StudentSurname and so, just select the surname and leave the date fields blank.

i tried the following:
Field :Date of Incident
Crirteria: [Forms]![frmSearchStudent&Date]![cboStartDate] And [Forms]![frmSearchStudent&Date]![cboEndDate]
Or: [Forms]![frmSearchStudent&Date]![cboStartDate] Is Null And [Forms]![frmSearchStudent&Date]![cboEndDate] Is Null

Field: StudentSurname
Criteria: [Forms]![frmSearchStudent&Date]![Combo0]

then when i tested this by leaving the date fields blank and selecting a valid student surname it simply returned all incidents (records) for ALL students not the selected one.

is it possible to achieve this? if so, could someone please help!

View 6 Replies View Related

Multiply Fields, Using The Sum Function.

Mar 17, 2008

Hi all, wondering if anyone can help me.

Im trying to a run a query to see the results of my table. but i am experincing problems, when use the SUM function.

I have constructed a query with three fields.
1) QTY.
2) Cost
3) Total.

what i would like is to be able to Multiply QTY & Cost to get the total.

so whan QTY Is 0 and Cost is £0.00. the query recongises it and changes the total should then be £0.00.

any advice on enabling the query is welcome.

View 12 Replies View Related

Multiply A Currency Field With Code

Apr 27, 2005

Currently i have:

If CIS = False Then
CIS_Payment = "£0.00"
Else
CIS_Payment = "£20.00"
End If

which works ok but what i want to do but do not know the correct way/syntax is:

If CIS = False Then
CIS_Payment = "£0.00"
Else
CIS_Payment = "Labour_Total*18/100"
End If

Where CIS_Payment and Labour_Total are currency fields, and CIS is a checkbox updated using an update query with the same info as detailed in another table (Couldnt get the conditions to work referencing the checkbox in the other table, so duplicated the box in both tables and used a query to sync)

Any ideas???

View 2 Replies View Related

Queries :: Multiply Time By Quantity

Apr 27, 2015

I have the time per item, and I would like to multiply that by the quantity, so I can tell the total time. But I cant find in access how to * data/time by a number.

View 3 Replies View Related

Forms :: Multiply A Text Box Value By A Number

Sep 10, 2013

I have a text box in a form that is producing a number from the query that the form is based on.In another Text Box i want to show the Value of the first Text Box multiplied by 3 because i am going to hide the first text box to only show the calculated number.

At the moment i have this in the control source of the text box [CountOfJobID]*3 but all i am getting is #####...I have set the format of the text box to General Number.

View 5 Replies View Related

Forms :: Unable To Multiply Values Of Two Number Fields Together

Aug 8, 2015

I'm trying to multiply the values of two number fields together, but it is not working. I used to be able to do this easily in earlier versions of Access. Here's the problem:

On the form, I need field A x field B to appear in field C. I've tried this as an expression in the build event function on the control, but it is not working. My code reads as follows: = (field A) * (field B).

View 3 Replies View Related

Tables :: Multiply Data Of Two Columns And Display Result In Third Column

Jun 24, 2014

My question is that can we do multiplication of data of two columns and result is automatically displayed in third columns in datasheet view.? Is it possible ?

View 1 Replies View Related

Forms :: Setting Focus To Control On Single Form Side Of Split Form

Jun 24, 2013

When I right click a row on the data sheet side of a split form an select "New Record" I want the curser to go to the first field on the single record side. I've placed this in the OnCurrent but it did no good.

Code:

If Me.NewRecord Then
Me!Descrfiption.SetFocus.
End If

Any way to set the focus to the single form Side of a split form?

View 4 Replies View Related

Forms :: Design Form That Looks Very Similar To Either Split Form Or Subform

Jun 2, 2014

Basically I need to design form that looks very similar to either Split Form or Subform. I have attached a print screen of what I roughly need. The form is split into two parts. In the first/top part there are some List Box/Date fields that act as filters to the bottom form, so the bottom form displays only records that match values in red. The second part of the top form has some field that require input from user and then these records are added to the bottom form. I was trying to use both Split Form and Subform and none of it is working,I have attached an example of database and this form would be based on data from Query1.

View 5 Replies View Related

Hide The Details Section In Form When Using Split Form View?

May 1, 2012

how to hide the the 'Details' section in my form when viewing it in Split Form. I tried to use

Code:

Private Sub Form_Load()
Me.Detail.Visible = False
End Sub

but that just makes the Details section look blank, as oppose to not having it there at all.

have only the Form Header and Datasheet visible in the Form View of my form. Similar to the 'Contact List' form in the Contacts Template that comes with Access.

View 3 Replies View Related

Split A Form

May 23, 2006

Hi,

Hi, I have a continuous sub-form and it has 3 fields date, problem and action.

i am currently ordering it by date DESC.

Want i am after if it is possible is too somehow splite so there is a gap or a line or something to patition if by months. There i will only every be 3 different months.

example
15/05/2006 | Problem | Action
11/05/2006 | Problem | Action
01/05/2006 | Problem | Action

27/04/2006 | Problem | Action
08/04/2006 | Problem | Action

21/03/2006 | Problem | Action
08/03/2006 | Problem | Action

Any help would be great.

Thanks
k0r54

View 1 Replies View Related

Forms :: Split Form In Navigation Form

Jun 4, 2015

I have a bunch of forms which have a split form layout, datasheet area to the bottom of the forms. I'm wanting to group all these split forms onto a "Navigation" form but when I click the tab for each form to be displayed in the subform area the datasheet split is now missing and all I get is a "Single" form view of what is a split form. How can I get these split forms to view properly in the subform area of the navigation form, I guess there's a property setting but I can't see it?

View 3 Replies View Related

Split Form Question

Dec 14, 2007

Hello,

I am working on a split form in Access 2007 that shows the entry portion at the top and the database view at the bottom. I would like the form to display all of the records in the table when opened, but I haven't been able to get it to cooperate. It only shows the new entries made during that session no matter what I do.

Any suggestions?

View 4 Replies View Related

Forms :: Two Split Views On The Same Form?

Jan 16, 2015

Is it possible (haven't found a way yet) to have two "split subforms" on a parent form side-by-side? When I try the multiple rows portion of the split view I created as a subform doesn't appear?

Want to have a form when I have search/filter/select record for table 1 (on the left) and table 2 (on the right) with a means in between to create a relationship which has a few parameters.

View 1 Replies View Related

General :: Filtering Split Form

Oct 20, 2013

i attached database & would like to filter the data by ISO N & Joint N.the first filter is working but there is small problen in filter joint N.

View 2 Replies View Related

Filter Button On Split Form?

Feb 11, 2015

I have this code set to a button on a split form. It filters out all the blank records for the "Status" column.

Private Sub cmdFilterPendingStatus_Click()
Me.Filter = "[Status]"
Me.FilterOn = True
Me.Requery
Me.txtFilterNamePlate.SetFocus
End Sub

I would like to do the exact opposite and filter out everything except for the blank records in the "Status" column.

How can I change the code to do this? I guess I should also mention that the "Status" field is a long text/memo box but I can easily change this to short text if I really have to. I realize that short text can do the blank filtering within the split form itself by clicking on that tiny arrow in the column header but I am trying to make it really user friendly where the user can just click a button to do this. The long text box has some options to filter but not for blank fields in a record which makes me think that this may not be possible to do if the Status field remains a long text box. Some examples for the filtering options that are available in the split form for a long text box are: Begins with, contains, ends with, etc... however, when I type "" to try and filter out everything except the records that have null in the Status field, it says that "" is not valid.

What can I do to get the results I need?

View 4 Replies View Related

Split Form With Spreadsheet View On Top

Oct 14, 2015

Is it possible to create a split form with spreadsheet view on top and when you click on any field in that line it shows a regular form with field information below?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved