Search results

  1. S

    Import txt file and Check dates

    I need to set up a macro that will import a daily ORDERS text file with data for the Columns below. I have set up a delete query to run before the daily file gets imported Business Date Subscription SubStatusCode EntitlementCode NumberOfSubscriptions Currency I then need to append this file to...
  2. S

    Import Txt file Macro

    I need to set up a macro that will import a text file with data for the Columns below. The text file (pipe delimited) will be daily and won't have any headers Business Date Subscription SubStatusCode EntitlementCode NumberOfSubscriptions Currency Make that 2 macroes I need the first...
  3. S

    Random Generator

    Hi I need to set up a Random Generator to select random account numbers for weekly competitions I have a table with just the account numbers. There can be anything between 10 and 500,000 account numbers depending on the competition and there can be either one winner or multiple winners Can...
  4. S

    Random Selector problem

    Hi I need to set up a Random Generator to select random account numbers for weekly competitions I have a table with just the account numbers. There can be anything between 10 and 500,000 account numbers depending on the competition and there can be either one winner or multiple winners Can...
  5. S

    Select records for a particular date

    Hi I am fairly new to Forms so need help please. The query below shows the fixtures, the current Position and Points of the Teams playing. I want to set up a form where I can select a future date from a list to bring up all the games for that particular date with all the columns below Date...
  6. S

    Rank / Position query

    Hi I am trying to set up a football predictor database but am having problems with the Position column in the League Tables. I have the Points, Goal Difference, Goals For etc., OK but I don't know how to add the Position/Rank column as the 2nd table below shows by Points then Goal Difference...
  7. S

    Rank / Position

    Hi I am trying to set up a football predictor database but am having problems with the Position column in the League Tables. I have the Points, Goal Difference, Goals For etc., OK but I don't know how to show the Position column as the 2nd table below shows by Points then Goal Difference Can...
Back
Top Bottom