Search results

Age is a number. We seldom use the Like operator on numeric fields. Take a look at the sample database in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?t=103312 ^

I think there's a typo in the second player rule as Jon remarked. ^

Jon's expression should be able to return the correct ages. For an example, you can see his query in the attachment in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?t=103312 Using Year(Date())-Year([DateOfBirth]) only deducts the year portion of one date from the...

When the Status field is included in the Group By clause, instead of returning one record per student per month, a student may have one to three records returned per month in the results. ^

Take a look at this thread and the sample database:- Update Qry (running sum) http://www.access-programmers.co.uk/forums/showthread.php?t=107837 ^

It would help if you could attach a stripped down version of your database (in Access 2000 or 97 format) for us to have a look at it. ^

No attachment. You have to compact the database and then zip it. The file size limit of a zip file for upload here is 393KB. ^

Instead of putting the code in the On Change events of the text boxes, you can add a command button on the form and put the list box requery command in the On Click event of the button. Hence, the user can fill in whichever text boxes he/she wants and then clicks on the command button to...

Take a look at Jon's sample in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=103312 ^

In query design, put the criteria for each field in a separate column like this:- ================================= Field: [TblRecruits].[cl_sname] Like [Forms]![MainListRecTrades2nd]![txtSearchBox2] & "*" OR [Forms]![MainListRecTrades2nd]![txtSearchBox2] Is Null Show: uncheck Criteria: True...

Use the Find Duplicates Query Wizard. ^

If your system uses ; as the argument separator rather than the comma, you should try using:- DateDiff("d"; Date(); Mid([Expiry Date];4;3) & Left([Expiry Date];3) & Right([Expiry Date];4) ^

Jon K posted an example in the Sample Databases forum. The criteria were built at query level without the need of VBA. Query By Form - using Text Boxes and Combo Boxes in criteria http://www.access-programmers.co.uk/forums/showthread.php?t=103312 ^

Put Is Null in the criteria for that field. ^

How did you add your large select statement to the string? The following is from Access' help file, Access 2K:- String Data Type A variable-length string can contain up to approximately 2 billion (2^31) characters. ^

CurrentDb.QueryDefs exists in ADO. (I'm using Access 2K.) ^

Format(Now(), "AMPM") From Access' help file:- User-Defined Date/Time Formats (Format Function) AMPM Use the 12-hour clock and display the AM string literal as defined by your system with any hour before noon; display the PM string literal as defined by your system with any hour...

It sounds like [Expiry Date] is a text field, not a date/time field. You can try using the Mid(), Left() and Right() functions to convert dd,mm,yyyy to mm,dd,yyyy. DateDiff("d", Date(), Mid([Expiry Date],4,3) & Left([Expiry Date],3) & Right([Expiry Date],4) ^

To ensure the correct data type is used in the comparison, you can use: If CDate(Forms![Study_Main]![ITSuppPropDate].ItemData(0)) <= Date Then ^

If I read your question correctly, you can put the following in the criteria for the date field:- BETWEEN IIf(Month(Date())<8, DateSerial(Year(Date())-2,8,1), DateSerial(Year(Date())-1,8,1)) AND IIf(Month(Date())<8, DateSerial(Year(Date())-1,7,31), DateSerial(Year(Date()),7,31)) So when the...