Search results

Hi, I have an .mde file that does the following:(and since it is an mde I cannot see how it is done) - A form asks for criteria (first you select a filter or no filter check button) - The form takes the criteria and (I think) with a Module and a Macro adds a piece of code to a pass through...

Absolutely Incredible!! Thanks a lot, really, it worked great I only have one more question I need for the function to start forecasting from the first value that is "0". I don't want it to overwrite my real values I already have, this function uses the first value and forecasts the rest, but...

DB Example Attached is my DB with which I'm trying to reach the data seen in the Excel Sheet Thanks for your help

need help, please anyone? I've tried to do this operation in ms access, kind of forecast the next 6 months or so. I can only get the first value and the rest appear as zero Here is an example of what I need to do, in Excel Help!!

I have three values A, B, and C in a table for the first month A=20, B=0, C=0 for the second month B=20 (value of A in month 1), C=110% therefore A=B*C =22 for the third month B should be 22 (value of A in month 2) C=110% therefore A=22*1.1 =24 And so on... Value C is a constant, but I need...

I am trying to forecast 12 months of sale in a query The only info I have is January Sales and a percentage change for each of the following 12 months. I multiply that change * january sales to get february forecasted sales. The problem is I can't multiply that new february value * change to...

The Fields That Are Null In Sales-forecast1 Query Are The Ones I Need To Fill Thanks

I have a table with Forecasted Sales: Month Value 2004/01 600 2004/02 1,200 2004/03 695 2004/04 3945 2004/05 500 Then I have a query which copies [Forecasted Sales] into another line in the next month so I can divide both values and get a change percentage Month...

Form With Listbox And Combobox (PLEASE HELP!!!) I have a Form with a combobox named "Line" and two Listboxes "ABC" and "MB". I need to filter a report based on the values of the three boxes. My report is being generated from a table named MAKBN010 and the fields equal to the boxes are "PROD...

Example: Line 1 Produced 500 pieces from 7:00 AM to 5:00 PM (shift 1) Line 1 Produced 300 pieces from 6:00 PM to 5:00 AM (shift 2) I need a criteria to separate second shifts because second shifts go over to another day. E.G. 6:00 PM Monday to 5:00 AM Tuesday morning, but I need to...

Nope, that is exactly what I need to identify

exactly!!! =)

What I have is a table where the fields are: date, production line, production in pieces. I need to identify if it was day - shift #1, day - shift #2 For example: Line 1 produced 200 pieces from 7 am to 5 pm that is shift 1 Monday. But it produced 200 pieces from 7 pm to 5 am (shift 2) but it...

Hi, In my company there is a day shift from 7 AM to 5 PM and a night shift from 7 PM to 5 AM. The problem is that the night shift extends to two separate days. What can I do to filter by shift if I have a list of all the dates with the hours? Is there a way to do this? Thanks

Wayne, Here is an attachment of how my file looks. I have several of those breaks whre the word "COIL" appears on the first line. Thanks

Hello, I need to import (or link) a txt file into Access but the file has hard breaks or "  " symbols. Access only imports the lines up until the first hard break, (the file has many of these). What can I do so the file is linked or imported completely??? Thanks Daniel