Search results

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

Hi Emmanuel Yes I will be importing the data to a table. . .does this mean the date query would be a part of the transfer text macro or do I run the query first. Yes, I will be using a button on a form Cheers Shark70

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

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

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

Excellent - Thanks Ashfaque, exactly what I'm looking for :D

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

Rank Excellent, cheers I needed it as a query so the 2nd option works Don't know much about VB yet but plan on learning it Thanks again Shark70 :)

No, I have the query in the correct order but I need to add another column to show the position of each team according to Points, Goal Difference, Goals For etc., Cheers Shark70

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

Thanks for that - I think it should work James

Hi I probably didn't explain that properly (I'm new to this) I already have the query which sorts the Points, GD etc., but I need to add a Position column and I don't know how to do that Thanks James

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