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

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

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

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