Search results

Try DateAdd("n",-2,[StartTime]) You say one minute but are reducing it by two?

Sounds like you need to change the joins on your query between Event table the other tables from Inner to Left Outer. This will select all records from Events that meet your criteria and put blank fields in where there is no match in the other tables.

Under your name field put in the criteria <>"Nametoexclude"

Join on VendorName, put your criteria in under VendorName?

This thread may help: http://www.access-programmers.co.uk/forums/showthread.php?t=110390

Thanks for the suggestions, I found simply using an input mask of >LA000009 works. (I got this from an old mdb someone else at work had done). I'll remember to post solutions rather than delete in the future!

Hi, I have a text box on a form to enter doc id's. The doc id's can either be a single letter followed by six digits or two letters followed by six digits. I can create masks for either of them but not so it allows either of the options to be entered, is it possible to create a mask to cover...

Hi Emily, I think this what you were wanting:

Create an update query, join the tables using Phone and CallerName. In criteria under Contact Email enter ="" I think that should work

Sorry answered a different question

I do something similar and use two queries to achieve this. (I don't create all the records at once, but transfer to main table when due and update next date due on planned table) Firstly you need an append query to transfer the records from the planned transactions to your main table, I...

Try: DateAdd("d",1,[DateOverpaymentBegan])

Try <>"" as your criteria?

Hi, See attached

Create a calculated column using the formula DateDiff("d",[timeofcallfield],Now()), this will show how long ago it was and it will change each time the query is ran.

Create a calculated column using the formula DateDiff("d",[timeofcallfield],Now()), this will show how long ago it was and it will change each time the query is ran.

Using this criteria under your date field should work <DateAdd("h",-24,Now())

Create a query and in the criteria under your date field enter Between [Enter Date From] And [Enter Date To] This will search between the two dates the user will enter in a pop up (parameter) box that appears when the query is run.

Like "*"&[search value]&"*"

Another way you could do it is to put in the Control source of your SS# field = Right(Trim([nameofyourfield]),4)