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 Replies


ADVERTISEMENT

Forms :: Split Record Quantity To Multiple Records Based On Quantity Per Package

Jun 21, 2013

I have a form for inserting invoices, and on the subform records I have a command button to print the labels, the label would contain the quantity of the product, so, if the quantity is ex. 11000 and package contains 2000 only.

so I have to print 5 labels with quantity 2000 and one label with 1000 qty

what I need to do, is when I click the label cmd button to insert the 6 records required to print the labels to temp table

View 8 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

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

Queries :: Sum Field Then Minus Quantity

Jun 3, 2014

I am trying to sum a qty field naming it 'TotalRecieve' and then minus a qty from that sum?

I've tried the following

Code : RemainingQty: Sum([tblReceiveDetail].[QTY])-[tblOrderDetail].[Qty]

but i get an error saying 'Your query does not include the specified expression as part of an aggregate function?

View 2 Replies View Related

Queries :: Calculate Stock Quantity With Query

Jan 21, 2014

I have a problem with calculating the total qty of two fields.

Code:
QtyMapics: Nz([MapicsQty];0)
QtySubComp: Nz([SubComponentQty];0)
TotalQty: [QtyMapics]+[QtySubComp]

When I calculate the values of the fields it pastes the values after each other.For example: if you have the values 1 and 2 (which should become 3) then the result is a value of 12.I've tried changing the function to SUM() but that didn't work.The reason I am using NZ() is due to the fact that some values have a NULL value in one or both of the fields and if NZ is not included it will not calculate anything.

View 4 Replies View Related

Queries :: How To Calculate Current Stock (Actual Quantity)

Oct 18, 2014

I have a query (Inventory Transactions Extended) in which i am trying to caculate current stock.

I have a form (Inventory Transactions Form) where i either add or remove Inventory Items.

I have used this statement to create a new field (Actual Quantity) to calculate current stock based on stock been added and removed:

Code:
Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition";[Inventory Transactions]![Quantity];-([Inventory Transactions]![Quantity]))

for some reason it does not work. It is not calculating current stock. If i remove stock it shows a negative amount based on the amount i removed, and when i add stock it shows a positive amount based on what i added

I have attached a sample.
[ATTACH][/ATTACH]
Sample.accdb

View 2 Replies View Related

Queries :: Split Quantity And Give Running / Accumulating Balance

Oct 21, 2014

I like to have my query splitting quantities and give me running/accumulating total.

See attachment as what I'm currently getting and what I would like to get.

View 5 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

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 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

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

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

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

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 2 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

Queries :: Employee Time In And Time Out Entry

Jul 18, 2013

I am trying to create an Access database where I can let the employees enter their time-in and time-out, at the end of their shift. I already created this function working, but running into another issue. Everyday, employees need to enter a break. Sometimes they take a break and sometimes they don't, if they work shorter hours. Thus, the break is not a default 30min and has to be enterd by the employee.

Below is the code I have to calculate the total hour:

txtCalcTime has the below code in control source:
=Int([CalcTime]/60) & ":" & Int([CalcTime] Mod 60)

Control source for this form "FrmTimes" property, in which Txtcalctime resides:

QryTimes
"QryTimes" query has the code below:
SELECT TimeID, TimeIn, TimeOut, Brake, DateID, DateDiff("n",[TimeIn],[TimeOut]) AS CalcTime
FROM EmpTimes;

This shows the total number of hours worked. But how can I make it to substract the break time entered by the employee in "txtbreak" on FrmTimes

View 12 Replies View Related

Queries :: Start Time - End Time Query

Nov 3, 2014

I have finger print machine and i already connect to it and get all log.then i tray to get data and here is the code that im using

SELECT Format(CHECKINOUT.CHECKTIME,"dd/mm/yyyy") AS CDate, IIf([CHECKINOUT.CHECKTYPE]=I,Format(CHECKINOUT.CHECKTIME,"hh:nn:ss ampm")) AS StartTime, Format(CHECKINOUT.CHECKTIME,"hh:nn:ss ampm") AS EndTime, USERINFO.USERID, USERINFO.Name, CHECKINOUT.CHECKTYPE
FROM CHECKINOUT INNER JOIN USERINFO ON CHECKINOUT.USERID=USERINFO.USERID
WHERE (((Format([CHECKINOUT].[CHECKTIME],"dd/mm/yyyy"))='10/04/2014'));

how i get end time due to CHECKTYPE]=O

View 1 Replies View Related

Queries :: Time Calculation Using Current Time?

Oct 9, 2014

I need a Select Query to display data on a form. When an order is appended to my table the field named Printed is updated with the time it was appended. When my form opens it needs to display the field Printed and a field I call MinutesFromPrint. This field needs to display the total minutes elapsed from the time in the Printed field to the current time. My expression is not working.

MinutesFromPrint: DateDiff("n",[Printed],Now())

Here are a couple of samples of my results when I run the query at 7:49 A.M.:

Printed MinutesFromPrint
2:35 60366554
5:07 60366402

View 11 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

Minimum Quantity

Aug 9, 2007

hi

i try to build an access form .

i have "big" table that fill in the name of the product , the quantity , and a minimum quantity.

the field : min quantity give us the quantity that is the minimum of the product.

i have a "minimum" table that has the list of the product and the minimum quantity.



i want to see the minimum quantity of a product , when i type the product (in the form if it possiable , if not - in a report)



eran

View 2 Replies View Related

Date & Quantity Query Help

Sep 28, 2005

Hi all,

I need help with what I think is a relatively simple DB. I'm creating a DB with 2 tables:

1) Inventory Balance with the following fields:
*Month
*FiFo Date
*Article number
*Quantity

2) Transactions with the following fields:
*Month
*FiFo Date
*Article number
*Adjustments qty (positive or negative)
*Receipts qty
*Invoice Create qty
*Invoice Void qty (negative)

I've added the month so I can filter any given month.What I want is a query that will calculate my closing balance (in qty) following the FIFO method and I haven't got a clue how to start.

Can someone help?

Thanks,

Ingrid

View 1 Replies View Related

Change Quantity To Rows

Feb 26, 2006

Im integrating a Scanpal Batch barcode scanner into my application, and need a little help with my label printing facility.

at the moment the scanner imports a list of barcodes and quantitys this is merged with my product table and results in a table something like this:

barcode | Description | price | quantity
123456 | my stuff | 9.99 | 7

i need a query to move this to my label printing however my print queue works like this

barcode | Description | price
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99
123456 | my stuff | 9.99

can a query do this?

Thanks

View 4 Replies View Related

I Need A SUM Of Quantity Depending Also By Date!

Jul 28, 2006

I am searching the net for a response to my problem but no result;
I have 1 BD access (Facture) in witch there is 2 tables (Entete_Facture and Detail_Facture) with a relation in Field (Numero_Fac).

It is very easy to use "INNER JOIN" to do a Query (Facture_with_date) fusionning the 2 tables, But I want to add to this query another column : " SUM(Qte_Article) GROUP BY Code_Article " as below:

View 1 Replies View Related

Query Doubles Quantity

Mar 28, 2007

I'm sure that this issue is simply. I've done it before, but for some reason I'm having problems today. :confused:

I have 4 tables in one database as follows:

1) Sort Table = Sort #
Sort Date
Qty Sorted
Qty Rejected
2) Sorter Table = Sort #
Sorter Clock #
3) Operator Table = Sort #
Operator Clock #
4) Defect Table = Sort #
Defect Type
Defect Qty

When I attempt to query these tables, my totals increase.
EX: I have 500 items sorted; 100 defects; 2 sorters; 2 operators and 100 defects of type 1 and 100 defects of type 2.

My query results are 1000 items sorted with operator 1 having 100 defects of type 1 and 100 defects of type 2 and operator 2 having 100 defects of type 1 and 100 defects of type 2.

My quantity of items is doubled because it took (2) operators to make the items. My defects are doubled because it took (2) operators to make the defects.

Please help.;)

View 1 Replies View Related

Parts Quantity And Orders

Mar 1, 2006

Hello All,

I am new to this forum :) and learning Access :confused: .
The Database
Tables:
Employees
Products
ExpectedQuantity
PartQTY
Parts

Most of the products are similar so they have the same parts for the majority. However they do not all have the same parts. So I created a parts table that contains all the parts needed for any product. Now each Product also can contain multiples of one part (such as wheels) where I would want to list the Product and the parts list and quantity needed of those individual parts for that product. Hence the PartQTY table.

Now what I want to be able to do, is go into a form where each record is one of the products. A subform (datasheet view) for that product that shows all the parts and the quantity of each part that make up the product. Such as 4
wheels, 5 screws, etc for Product A.

I would like there to be an ExpectedQauntity field in the main form which once you found the product you can enter in the number of that product expected. Then this Qauntity would be multiplied by the qauntity of each part required (in the datasheet subform a column with =[expectedQTY]*[PartQTY]) and list next to each part the number needed to order. So if for product A the expected quantity is 50 I would have to order 200 wheels and 250 screws for that product.

A report would Sum each part qauntity after the expectedqauntity has been entered for each product. So I could print a report that tells me how many of each part we need to order based on the expected qauntity of all the products.

I think I am complicating things and would like a fresh mind to assist me in which direction to go.

Thank You,
Adam

View 9 Replies View Related







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