I am drawing a blank on how to proceed with this requirement and was hoping someone out there could help me.
I am creating a graph that shows all of the orders we have taken, shipped, and what we have bid on. There is a table that holds the customer, no of units ordered, no of boxes per unit, number of units to ship each week and start date.
I need a formula that will calculate all of the week ending dates until the no of units ordered is 0.
For example, Capital ordered 100 units, 12 boxes per unit, 2 units to ship per week and shipments are scheduled to start on 2/19.
This information is diplayed on a graph. The graph shows all of our open bids and based on shipments per week, displays a forecast of what's coming up.
How can I place numbers side by side in the units, tens, hundreds etc
so if I have expr1, expr2, expr3........and I want them to appear side by side.
so expr1=1, expr2=3, expr3=0
This would appear as 130
However if expr1=0, expr2=3, expr3=0
I would like tis to appear as 030
I am sure I am going about this the long way but I am trying to create a query that wites out the full ip address i.e. 111.111.111.111.......not really sure to go about this so I am going to try and strip everything down to 1 digit and then rebuild!!! Unless anyone can think of an easier way to do this?
I have a table with some prices that are charged by the pound and some that are charged by each.
tblPrices ID 1 - 1.00 per pound ID 2 - 1.50 per pound ID 3 - 2.00 per pound ID 4 - 5.00 each ID 5 - 7.00 each
My form is set up so that way I count how many containers I have and their weight, separately. I need ID 1 through 3 to do the math based on the pounds (essentially $1 per pound at 36 pounds) and ID 4 and 5 to do math based on how many of each are there ($5 each, and there are 3 of them).
I am trying to use the Excel worksheet function "Forecast" to calculate from existing data in my database. I have successfully gotten the data points into arrays, but when I try to call the forecast function I keep getting the following error: "Unable to get the Forecast property of the WorksheetFunction class". I have imported the object library. This is on a company computer and I do not have write privileges to the C: drive. The database resides on a network drive.
Am I facing some sort of security issue?
Public Function xlForeCast() As Double Dim MyHeight As Variant 'Will be the point for which you are forecasting, in this case height Dim MyRange() As Variant 'Will be the independent element of the forecast function Dim MyRange1() As Variant 'Will be the dependent element of the forecast function Dim MyArray() As Variant 'Temp array to hold the query result set values before being split into the two preceding arrays Dim db As DAO.Database
Hello, I'm totally new to this forum. I have a database with the vehicle information in one table. The Vehicles' Odometer reading stored weekly in another table. I have the vehicles' service history with the Odometer reading of the last service in another table. The first two tables are linked by parent, child relationship. I now want to forecast the approximate vehicle service due date based on this information. All I want to do is extract the last 10 Odometer Readings from the Weekly Odometer Readings Table. Find the Average Kilometers with those 10 values. Come up with a figure. Determine the last value entered in the Weekly Odometer reading along with the date. Pull the last service history for the vehicle, with the odometer reading and date. Compare these 2 readings to see if the vehicle is due for service, and if so based on the average Kilometers run every week, determine the approximate date the vehicle is service for due. I badly need help on this one. So if someone could help me on this please let me know. Thanks
I have a database being used to track and bill therapy units. I have a table that stores the pre-authorizations that tells me within a [start date] and [end date] I am limited with X amount of units (that is all the client's insurance and/or funding source will pay for within the time period). I also have about 4 different codes I can be authorized for which is also stored in this table - each code a separate pre-auth record.
Another table is where I enter in the type of therapy (service code) I've completed with the client. I put in the Service date, start time and end time and it will automatically give me the amount of units to bill (1 hour=1 unit). If I happen to choose a code or enter in a service date that does not match up with a client's pre-auth (Service date is between start date and end date and matches code from pre-auth table) I have a simple text box that says "No auth for this code or service date" due to an IIF statement in a query. I'd like to take this a step further and give me the remaining units for the pre-authorization left when it does find a match.
What is happening is when it finds the authorization, it's not taking into consideration all the services I've done for that time frame. For example: I have a pre-auth from 12/1/12 to 1/31/13 for code 90806 for 12 units. I served the client for that code a total of 10 units thus far. I can't figure out how to link my 4 service records dated 12/3/12 (2 units), 12/16/12 (4 units), 12/27/12 (2 units), and 1/3/13 (2 units) to add together and then subtract from my auth for 12 units. I know the dates are the key but I'm lost.
I need to create a production forecast form based on previous sales history.The history is based a sales and grouped by month & year
So on the form, which needs to be a continuous form, I want products to show as rows and months as columns The sales history per month needs to be displayed as well as a field allowing to user to enter the production forecast.
I can write the sales history to a temp table.However I never know how many months history the user is going to want displayed at run time. Could be 3, 7, 12 or 15!
Attached spreadsheet shows what I am trying to achieve. Is this possible and if yes, how would I do it?
This is something I've been working on that very nearly works until it get to point DM
What I need to do is convert a build time for a single unit which is stored as mins:seconds into a build time depending on number of units being built then display the time as Hours:Mins.
I don't know of any functions in access that do this so have been playing with the code below which works upto the point of DM where I need to add the mins together then if more than 59 add the hour(s) to hours and then use the mins part as the total mins.
It needs a lot of cleanning up as been playing but hope somebody can help.
T = The Time IE 2:43 N = Number of units being built
Function GetTotalTime(T As String, N As Long) As String Dim M As Double, S As Double, Y As Integer, MZ As Integer, MS As Long, H As Single, Min As Long, MM As Long Dim DM As Long, Z As Integer Y = InStr(T, ":") If Y <> 0 Then 'Do The Mins Convert To Hours First M = Left(T, Y - 1) If M > 0 Then M = M * N 'Minutes * Number Of Units 'Convert Total Mins Into Hours M = M / 60 Z = InStr(M, ".") H = Left(M, Z - 1) 'The Left Over Mins Min = Mid$(M, Z + 1, Len(M)) End If 'Do The Seconds S = Mid(T, Y + 1, Len(T)) If S > 0 Then S = S * N 'Seconds * Number Of Units If S > 59 Then 'Has Minutes S = S / 60 'Convert Total Seconds To Mins.Seconds MZ = InStr(S, ".") MM = Left(S, MZ - 1) 'Dont worry bout odd seconds Else MZ = InStr(S, ".") MM = Left(S, MZ - 1) End If End If End If 'Now Add The Mins Together then / 60 to get hour /mins and add the hours to hours the remaining mins are the total mins element for build. DM = MM + Min
