My order dates of service load from a text file and contain "today minus 1, plus 3". For example, using today's file, this equates to yesterday's date
(4/11) through Friday's date (4/15). What I want to delete using a SQL
command daily that requires no input from me is yesterdays info.
How do I write a SQL command that states delete any date less than today? I
know this is easy, but I've been struggling with it for about an hour now.
Re: Invalid Procedure Call ... This is done with about 9 SQL strings total,... My problem is occuring in the SQL string that takes the raw ... Fields: tag, pointid, date ... This SQL statement is put into a string and executed in VBA.... (microsoft.public.access.queries)
Re: Complex RecordSource ... The SQL didn't quite return what was needed. ... record returned by the query.... FROM Bill... as the last name on the name tag of the spouse. ... (microsoft.public.access.reports)
Re: Can the number of records to return be specified in an SQL query ... just add order by that tag at the end of your SQL query ... Now depending on the SQL Database you are querying you can put RANGE 51,100 ... I am trying to revise an app which has a grid that browses an entire ... I would like to do this with a query to keep the data ... (microsoft.public.fox.programmer.exchange)
Re: Suppress Element when Value is NULL in for XML EXPLICIT ... The tag name ShippingDate in is considered what ... It will disappear if the row is not being returned ... The xsinil indication is a feature in SQL Server 2005. ... the schema definition.....apologies but I am not hugely familiar with ... (microsoft.public.sqlserver.xml)
logging users against an update ... I don’t want to upsize to sql.... I can then see how many records a user has updated Dailey?...James...Prev by Date: ... (microsoft.public.access.security)
