Recent content by @stan

delete Query How do i Specify the table containing the records that I want to delete?

IIF works as long as I dont try to do it from within the same query thank you all for your help

Brain thank you for asking about the field name, Iv done that a fee times here in the middle of the night

the first is, the [selected date ] from a form -[entry date of object field] most come out + but for those who's [entry date] starts later in the month in question thiers comes out as a -

the field name is an alias, I created in the query to create a number from two different dates.

Ok, tried, when running it thinks that the [fieldname] is a parameter and askes me to enter parameter value....

I can not have any negitive numbers show up in my field so I need to round up and negitives to "0"

they are text feilds

Ok, iv droped the reformaing. it is giving me records for only that fall inbetween the months and not the years.... so if I input 01/01/14 and 01/31/15 it gives the all records for the 1st month of 14 and 15.... If I input 2/2/2014 and 10/2/2014 it gives me all the dates between there for 14...

Ok while in the query how should it look? the field name is 'shortdates" With out useing the Left, 10 how should I format it into US FORMAT? thank you

it is stored as a long date but I am Using the "left([Date]),10) and it is in the mm/dd/yyyy

Help! I have a report with an inbeded query. I am running a between [start date] and [finish Date] this worked fine last year but now it only wants to show dates for this year. is there somthing that I am missing?

Re: Force shut down ("kill switch/trigger") Please do tell about the "kill switch/trigger" so that I may build that into furture systems. Thank you

I am in need of updating a table in my system but can not due to a coworker having this data system open on thier pc that is in a locked office. Is there a way I can log them off the back office or force thier access to shut down? Thank you Stan

I wonder what I screwed up, i'll give it another run.... thank you for your help