Search results

Congrats to you both :-)

I've sorted out the problem I had all the data in the report header instead of Detail

I'm trying to run continous reports based on a query that returns more than one record at a time, if you know what I mean :confused: At the moment I run the report based on 1 record at a time & the record details fits all on one page I now need it to print one record at a time on each page as...

Thanks ;) I sheepishly looked for a way to delete my post without giving the game away but I was too deep in the mess & could not do anything else but this.....:o Cheers

What's wrong, the typo, my query or both? :D I see my typo so perhaps I should't try rushing too many things at the same time, will clear my head & try again :o I meant returning 10% from the following values 10% of 165 records is 16.5 - running query returns 17 records 10% of 29 records is...

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