Search results

Start simple. Build a blank query and put that in the SQL. Run it and see if you get the desired results. It works on my system (Access 2010), and I trust Allen Browne. It should work in 2003 as well, based on http://perfectparadigm.com/tip001.html which was written back then.

I don't even think he's asking about another database. I think he just wants his switchboard to have a combo of all Reports in THIS database. Per http://allenbrowne.com/ser-19.html SELECT [Name] FROM MsysObjects WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like...

Is it a warranty repair if you do it within 7 days of... what? DatePurchased?

Where is Compact & Repair in 2007/2010/2013

Can you post the SQL of the query that doesn't work?

Yes, if you are trying to use one or more criteria you want AND. The user in the other thread was picking any one criteria to filter by, hence OR.

Can you give some example data, along with the results you expect?

Why would you make a table with today's date? Date() will return (today) every time. Now() will do it with a timestamp as well, if you want. I think I'm missing something in your process. A query should do for your needs, comparing Date() to your DateField (DateShipped? DateCompleted? You know...

I would enter it into the query behind the form, and then tie the field to display it to SumImportExport or whatever you call the calculated field. That also allows you to debug it a bit. However, is this form a summary form or data entry? I.e. is the sum field in the header/footer? Otherwise...

Chris, what I usually do is build the WHERE string sequentially, rather than nesting a whole mess of IIFs. Look at http://www.access-programmers.co.uk/forums/showpost.php?p=1320082&postcount=6

I think Paul dropped the IIF. = Sum(IIF((IsNull([OffPeakDay]) And IsNull([OffPeakHour])), ([Import]-[Export]), 0)) Also aircode, doublecheck your parentheses.

You can make it more flexible by having an unbound search form with two fields on it: From: & To: From:'s 'default' value can be Date() and To: can be Date()+7, but the user can change it if needed.

So you want to see what is scheduled from today to (example) a week from today? WHERE [RepairScheduledDate] Between Date() And Date()+7;

What happened when you tried the code? Error, nothing, bad result? We need more information... Probably you want something like Forms![Form2].Filter = "[student no] = " & Forms![form 1]![student no] Forms![Form2].FilterOn = True or DoCmd.OpenForm "Form2",,,"[student no] = " & Forms![form...

If (IsNull(Me.[oldoffset1]) Or (Me.[oldoffset2]) Or (Me.[oldoffset3]) Or (Me.[oldoffset4]) Or (Me.[oldoffset5]) Or (Me.[oldoffset6]) Or (Me.[oldoffset7])) Then ...although, if you're actually trying to check for Nulls in any of those, you need to parse that separately. If...

DoesstrWhere = "[WorkID] = " & Me.[WorkID]not work?

Is ClientID a field in your report? You can make it Hidden if necessary.

Did you try the Expression Builder? If none of that works, you can try uploading a stripped-down copy of your database for someone to look at.

So to be perfectly clear, do you ever need to limit by more than one criteria at once? Say, only Special Events this Calendar year? If not, this should be pretty simple. Something like: Dim searchStr As String If Not IsNull(Me.cboYear) Then strFilter = strFilter & "Year([ProgDate]) = " &...