Search results for query: *

My query qryGDATE3 won't work. I get message "Data type mismatch in criteria expression" on execution. qryGDATE2 does work correctly. I just want to select all the results that come up with a DOW equal to "Sunday". How can I make this work ? Query - qryGDATE1 SELECT N_League.* FROM N_League...

Basic question here. I have a main form Projects based on tblProjects. I have a main form Clients based on tblClients. How do I make a subForm for the clients in the form Projects ? Client_Contact is the common field. I know nothing about subForms

I have the following code in a Form : Private Sub Client_Bldg___Change() Dim Client_No As Variant Dim Client_Addr1 As Variant Dim strCity, strState, strZip, strCrit As Variant If Left(Me.Client_Bldg__, 1) = "1" Then Client_No = 1...

I have a Form where one field in the Table is Transaction_Date which is entered by the operator. I also have another field in the same Table which just contains the TYear. This field is not needed to be in the Form. I want the TYear to be automatically updated after the Transaction Date has been...

HAs anybody written code that would scramble and descramble data within an Access Table ? I have sensitive data like Names, Social Security Number, and Home Telephone Number in my database. I would like to be able to totally scramble the data within the Table while preserving the Structure and...

I have an Access database documenting my Programme Collection which has over 2,000 records. I want to design a Form which selects records based on the value of the field "Competition". I have an SQL query which can select all the programmes for a particular competition. I can make...

On my windows XP I placed a link on the Desktop which I now want to delete. But it won't let me. When I click on the right mouse button over the link (which is a URL link) the Cut feature is not highlighted. I have looked in the list of items in desktop and can't find it even if I include hidden...

Is there a better way to do this ? My SQL query SELECT CUPALL2.YR, CUPALL2.RD, Count(CUPALL2.YR) AS [Count] FROM CUPALL2 WHERE RP="r" GROUP BY CUPALL2.YR, CUPALL2.RD ORDER BY CUPALL2.YR, Iif(CUPALL2.RD="F","Z", CUPALL2.RD ) UNION SELECT CUPALL2.YR, "Z -...

I have a Form based on a Query which generates the following fields: Year, Count for Round1,Count for Round2,Count for Round3,Count for Round4,Count for Round5. Most years the Count for Round5 is going to be zero. This Form has a Default View of Continuous Forms so that I can see the output as a...

I need help on Updating a Table. Can anybody fix my UPDATE SQL ? I have a Table SEASON&Count which has 3 all numeric fields:SEASON,Number_Of_Teams,Number_Of_Games. I want to update the Number_Of_Games field which is calculated as the number of games played in a season. SELECT CUPALL2.YR AS...

I have a form which displays my 100+ records in a particular sort order based on a query. I want to incorporate a radio button (option group button) to select a particular sort order. Right now, I have two SQL queries which sort the same records in a different order. I have an option group...

Having just had a successfull response to my first question, I'll have a go with this one. I think that this is a bit harder. I have a database of Football Results. The Table looks like this: Field Name Data Type SEASON Number HomeTeam Text HomeScore Number AwayTeam...

KavJack (Programmer) Jan 7, 2002 The following code returns a year and a count. SELECT CUPALL2.YR, IIf ( IsNull (Count(*)) ,0, Count(*) ) FROM CUPALL2 WHERE CUPALL2.YR>1944 AND CUPALL2.RD="R3" AND CUPALL2.RP Is Null AND ( (CUPALL2.L1="N") OR (CUPALL2.L2="N")...

A week ago I had Office 97 running under Windows 95. I had to upgrade to Windows 98. Now my SQL containing functions LEFT and MID won't work. InStr is working though. What do I have to do to get my SQL working ? This SQL is suposed to find all teams named United in a database and replace it...