Search results

I did try to remove the TOP 100 but but had errors that I could not work out what I was doing wrong. I did however discover that by changing it to SELECT TOP 100 PERCENT it appeared to work I tested it on 165 records which is 16.5% I returned 17 records then 29 records which is 2.9% returning 3...

Actually instead of removing it i changed it too TOP 100 PERCENT & I seem to get expected results this time Thanks

I can't find any help files that does what I need :confused: I don't want the top 10 or the bottom 10 just 10% of records based on the result of another query. The results from the first query could return different amount of records each time it's run 100 records should return 10 200...

I think I'm almost there:D I need random 10% of records based on the results of a query testing it using this SELECT TOP 10 PERCENT * FROM [SELECT TOP 100 * FROM qryPostInspectionLesYates WHERE qryPostInspectionLesYates.Status = "Invoiced"]. AS qryPostInspectionLesYates ORDER BY...

Thanks Namlin Works great

Sorry, difficult to explain properly. All I wanted was to be able to return a % of records from an existing qry, in this case it will be 10%.

I've got so far as to create a qry that captures the data required for the random 10% selection Then created another query based on the first that selects one record from it using this code SELECT TOP 1 * FROM [SELECT TOP 100 * FROM qryPostInspectionLesYates WHERE...

Not sure how I could use this to select a percentage from a preselected list already produced in a query the job no's i'm refering to will start from 20000 so far it's now up to 23920 & counting. the idea is every month I will generate a report for all completed jobs on the system then run...

I can using access 2003, I use a company called clickatell.com for my sms credits. here is an example of the code I used on my application Option Compare Database 'Used for Text Messaging interface Global Const strClickatellURL = "http://api.clickatell.com/http/sendmsg?" Global Const...

Thanks everyone, will have a look & let you know how I get on

Does anyone know how to randomly select a % of records returned in a query? If there are 100 records I only want 10% to be returned & all random. I don't want to have to manually do this each time & I'm hoping there is a way to do this in Access. Each record will have a unique field that the...

The code I am using originally allowed me to store one Cell/Mobile No Global Const strClickatell_From = "&from=44743649017" When a SMS is sent it displays that no as the sender to whover reads the message The problem there was that I could only store one no & not the phone number of the...

Hi DCrake, Yes my form is open when the module if called, I thought perhaps my syntax was incorrect. Would I need to do something like this? X = Forms("frmSendSMS")("txtMobileNo") Global Const strClickatell_From = "&from=X" ' Staff I get a compile error when I tried :confused:

What am I doing wrong? I'm trying to reference a field in a form via a module run from a command button on the same form but it's not working form is called "frmSendSMS" field is called "txtMobileNo This is part of the code in the module Option Compare Database Global Const strClickatell_From...

http://access-programmers.co.uk/forums/showthread.php?t=187853

"I think it should be explained in the brochure that the local store does not sell proper biscuits like custard creams or ginger nuts." "It's lazy of the local shopkeepers to close in the afternoons. I often needed to buy things during 'siesta' time - this should be banned." "On my holiday to...

The South - You Gotta Love It! Alabama A group of Alabama friends went deer hunting and paired off in twos for the day. That night, one of the hunters returned alone, staggering under the weight of an eight-point buck."Where's Henry?" the others asked. "Henry had a stroke of some kind...

Re: Too icy to go to work Fake! Someone threw down a couple of coins then took the picture ;)

I left my beers in the conservatory & found that they were colder there than in the fridge :D

There are some trains still running I believe but most of the bus services are effected Not sure about the rest of the country, but Liverpool may not be as bad as other parts. I love the snow, I even brought my snow boots into work so I can still take my lunch break walk rather than sitting in...