Queries
in [Access]
|
How do I access multiple records within a query? I am trying to calculate the total quantity of components in a nested Bill Of Materials where the true quantity of any sub-level component is dependant on the quantity of the previous higher component. Level Item number Quantity 1 A123 1 2 A124 2 3 ... 7 Mar 2010 11:49
Access 2007 - Date Serial I want to set up a criteria for the Date Serial where I want to be able to run a report that will allow me to enter a date and then be able to tell me what is going to be coming up due as of 30 days from the date entered. I am not sure what the formula is to make this happen and anything that I look for is not ... 5 Mar 2010 19:38
divison by zero error this never used to show up till now. 'Compute Appraisal Value If BBG("Orig# LTV").Value < 1 Then ltv = BBG("Orig# LTV").Value Else ltv = BBG("Orig# LTV").Value / 100 loantape("OrigAppraisalValue").Value = CLng(BBG("Orig# Amt").Value) / CLng(ltv) ... 5 Mar 2010 13:58
query to trim name field? Hello, There is a name field (last, first) in my query that I would like to create a new field that only return the last name. What is the proper function to use? Thanks Example: Johnson, sam Return: Johnson (without comma) ... 5 Mar 2010 12:50
calculated field - difficult I have to make a calculated field in the query where the value from one table is deducted from the value in another table. Is that possible ? Here is the example: 1st table (created from linking 2 tables): Needs ItemName quantityNeeded date aaa 20 03-feb-10 aaa ... 8 Mar 2010 08:36
Query prompt one column for multiple random values I can write a query that prompts one field for a specific value, but would like user to enter multiple criteria Example - Lot numbers range from 1 to 140 transportation back to original consignor is provided by one individual, he is picking up lots 2, 50, 76 and 32 so I want to have these values on the loa... 5 Mar 2010 10:33
Microsoft SQL Server Management Studio / Convert Date This isn't exactly a Microsoft Access question, but I didn't know where else to go. I am using Microsoft SQL Server Management Studio. The table and field name are “dbo.EncounterData.CreateDateTime” The results are formatted like “2010-03-02 10:36:52.527”. Would you know how I can use the Convert function t... 5 Mar 2010 10:33
Concatenating with and/or without a comma My parameter in Criteria in a query is the following: Contact: IIf(Trim([Surname])="",(Trim([FirstName]),(Trim([Surname]) & ", " & Trim([FirstName])))) I am intending it to give me: Surname, FirstName but if there is no Surname, then: FirstName (without the space and the comma) Can somebody please cor... 4 Mar 2010 18:05
Query of a subform I'm looking to create a query that will pull subform data into it. The subform (four of them) have data that gets manually entered. All the boxes in the subform have dropdown boxes except one. This box is used to enter amounts. Will it be possible to pull this data? I can't seem to find it when I use the Query... 4 Mar 2010 12:22
Select to reference an other record or row Hi, I have one table on Microsoft Access 2007 like this Table1 Field1 Field2 Field3 Field4 1 Data1 1 2 1 Data2 3 4 1 Data3 5 6 1 Data4 7 8 2 Data5 9 10 2 Data6 11 12 2 Data7 13 14 2 Data8 15 16 Then I need a query to get something like this Query Result Field1 Field2 Field3 Field4 1 Data1 1 2 1 Dat... 4 Mar 2010 12:22 |