Search results

I have the following table:- Staff Name, Day, Hrs, Wk1, Wk2, Wk3, Wk4 Total Hrs Bob, Fri, 2, 1, 1, 0, 0 4 Bob, Fri, 2, 0, 1, 1, 0 4 Bob, Mon, 3, 0, 0, 0, 1 3...

have done. It's made no difference.

I've started receiving this message on an update query. Any ideas ~ I'm using Access 2000. I've also noticed that I have an unsual record in my table which I can't delete due to the same message. Although my query should not be looking at this record.

I have a query that uses information from a form to return a data set. In this query I also want to exclude certain codes i.e. CSC01, CSC02 and have therefore typed, not like CSC01 and not like CSC02. This works. I have explicitly told the query these codes. I have these codes in a table...

Fixed It. If Not Me.Title Like "NVQ*" Then MsgBox NOT AN NVQ Else MsgBox AN NVQ End If Thanks

I've now created basic code that tests this. i.e. If Me.Title <> "NVQ*" Then MsgBox NOT AN NVQ Else MsgBox AN NVQ End If It still doesn't recognise this. Any more thoughts anyone?! Thanks

This still doesn't work. I'm getting a compile error, expected expression. Thanks

Nope, this has the same effect. Surely, this is a standard operator that can be performed. Regards

I have some code where the <> Operator is not working. I've not noticed this in the past, and I've not altered anything. If [Counter].Value = 0 And [DLHours]> [CLHour] And [Title] <> "NVQ*" And [LoadBandYN] = "N" And [Value1] > [Value2] Then <peformsomething> End If How can I rearrange this...

Not in query, you can't.

I have a string field i.e. YYYNNNNNNNYYNNNYYNN that will always start at one and always finish on 53. I'm using InStr(1,[Weeks],"Y") to find the first Y in the string, but how do I find the last Y in the string? If the first Character in the string is 28/07/03 (every Monday) - can I tell the...

Not possible. These records must contain this information in the first place fo all sorts of other reasons. Thanks Anyway.

Compare Previous Record (MS2000) Here goes .... I have a register table that contains: COURSE CODE - ROOM - TUTOR - DAY - START TIME - END TIME One - 202 - Somebody - Tue - 09:00 - 10:00 One - 202 - Somebody - Tue - 10:15 - 12:00 One - 202 - Somebody - Tue - 13:00 - 15:00 This is what I...

Hi I have a query that displays the following data. Subject Weeks Basic Skills 7-13 Basic Skills 15-21 Basic Skills 23-30 Basic Skills 32-53 Outdoor Skills 7-13 Outdoor Skills 15-21 Outdoor Skills 23-30 Outdoor Skills 32-53 I would...

Thanks for replying. First I wanted the field in the query to read 09:00AM and not 09:00 AM before an export to Excel. I'll just have to tweak the data in Excel to remove the space. Thanks Anyway.

Hello Is there a function, ideally in a query, that enables a date/time field stored as 13:00 to be converted to 01:00pm for example. Thanks

I understand reserved words. The fields are not really called that I've simplified for the question. Year is academic year i.e. 03/04 or 04/05. (text) Code can change within Acadmic year (text) Day is Day 1-7 where 1 is Monday. (number) Year is not a foreign key. Thanks.

That's just it I don't know. I've tried copying from another users code and tailoring it to mine but I can't seem to do it and I can't also find the bloody code now! Something along the lines of SELECT DISTINCT FROM (table created) as ? INNERJOIN (another table created with totals?) Where...

Advice creating SQL syntax for Unique Count - SORRY! Hi there Sorry, for this posting as its been explained a thousand times over but I'm still finding it hard to write this query. I would like to Count Unique days of the week for a particular code and year. Year Code Day 03/04 VFOCE 1...

This has not really answered my question. Yes the Start and End Date are stored in tables. I don't know how to reference tables from a Module. Thanks Dawn