Recent content by leejevans

Hi I wish to update the top X records in a table so that a YES/NO field is set to true. I have figured out how to update all records:- UPDATE tblList_Contractors SET tblList_Contractors.Selected = True; I'm just stuck on the bit where I pick out the first X! Many thanks Lee

Now that is a simple, but excellent solutioN!

Hi I am attempting to setup a database that will allow my organisation to select contractors to invite to tender for work. The contractors must be selected at random to ensure fairness. I have a command button - "Generate List" when this is clicked it runs a query which selects five random...

<bump> <Just a BUMP>

Hi, in that case I would like to display the number of days during JAN, FEB and MAR. Hope that helps?

Hi all, I have a table of employee sickness / absence records with the following structure and data: I have figure out how to write a query which displays the number of days taken for each sickness (END_DATE minus START_DATE). My problem is that I would to write a query to display the...

that sounds complicated LOL?

Hi, I am trying to add a chart to a form/report which will show sickness for each month (ie. 12 fields). When I goto insert - chart and start adding my fields Access tells me I'm only allowed six! What am I doing wrong? Cheers Lee