Search results

  1. S

    Query Table1 date to Table2 column1 begin date range to column2 end date range

    The fiscal week/month/year always begins on Mondays and ends on Sundays. The first day of the current fiscal year was Monday, 5/27/13 and June is the first month of our fiscal year. The last day of fiscal June was Sunday, 6/30/13. This current fiscal month of March began on 2/24/14 and ends...
  2. S

    Query Table1 date to Table2 column1 begin date range to column2 end date range

    Thank you. But I don't know how to do that.
  3. S

    Query Table1 date to Table2 column1 begin date range to column2 end date range

    month period tablecompl date range1compl date range2fiscal month...
  4. S

    Query Table1 date to Table2 column1 begin date range to column2 end date range

    The fiscal months are based on four 5 week months beginning with first fiscal month June begins Monday, 5/27/13 and ends Sunday 6/30/13, then two four week months follow then 5 week month to begin the next quarter, etc.. The fiscal year ends 5/25/14.
  5. S

    Query Table1 date to Table2 column1 begin date range to column2 end date range

    Hi, I have a table of data with a column "completion date". I have another table defining "fiscal month" column with 'begin date" column and "end date" column. Do I have to use SQL to create a query to report back which fiscal month the completion date falls in?
  6. S

    Hello from West Chicago, Illinois USA

    Hello, posting for the first time but I've searched your postings in the past and was saved a lot of wasted time. I've been using Access tables, queries, forms, reports for about 1 year. Been using this software for inventory type analysis. Red Prairie load numbers to Warehouse inventory...
Top Bottom