Recent content by jamesk1979

Thanks klaz and Chris, I'll give these a try...

Hi all, I'm a bit a SAS novice so apologies if this sounds a bit dumb. I get a backup of a system file each day, with the date tagged on to the end of the dataset name in the format YYMMDD. At the moment I am changing my SAS programs each day to look at the latest version, e.g. today I...

Thanks Jerry, That looks like a better approach that what I had been trying. I'll give it a go. Cheers, james.

Hi all, Is it possible to update multiple rows in a table with a value from a single row? I have a table like so... ID Field Value PlanB 39 Sys 1 40 PlanA 0001 41 MaintDate 2005138 42 MaintUser Abcde123 43 Sys...

Hi all, Is it possible to have a report based on a cross-tab query which does not produce a message like this; "The Microsoft Jet database engine does not recognise '[User 1]' as a valid field name or expression." when there is no records to count for User 1 against the row value? I have a...

Thanks for the help guys.

Thanks lupins, that's exactly what I've done. Cheers...

Hi all, Is it possible to set up a cross-tab query with user input date parameters (i.e. Between [Enter Start] And [Enter End])? I can run a date parameter query if I set the date parameters to specific dates (i.e. Between #19/03/2004# And #21/03/2004#) but if I try to do it with the user...

Thanks rudy. Much appreciated.

Yes, there is an autonumber value on each row. I want to keep the row with the lowest autonumber value. Is this possible? Thanks, James.

Sorry, I need to keep the first instance and delete the remaining ones. Cheers, r937...

I have a table with the following fields; cus_name acc_num acc_branch cus_fname cus_sname etc... I need a query which will scan through the table and delete any duplicates in the acc_num field (i.e. if there are 6 entries for 123456, I need to keep one and remove the other 5 from the table)...

Any help will be much appreciated (as usual). I have a table for training courses, with three fields; 1. ID 2. Course Name (eg. Word, Access, Excel etc.) 3. Course Type (Internal, External) What I want to do is create a form (with a subform if neccessary) that pre-populates the read-only...

Cheers ETID, will give it a go.

I need to schedule a delete query in Access 2000 to run daily, using the Windows NT Scheduler. Each time I try the task fails, even when (I think) I have the correct address in the scheduled task. I can't use the HAL utility mentioned before, due to licensing issues. Any help will be much...