Search results for query: *

jennyd41: In one instance I have the field calculate a date from: IIf([Indicator]Is Null AND [DateField1] Is Not Null, [Datefield1]-5, [DateField2]+3). Like I said, this gives me the result I want, but in the MakeTable, the field is formated as text and not as a date field.

Here's a monkey on my back. I have a MakeTable query that adds or subtracts a number of days from a date field if a condition is true, false, or null. This works fine. However, the new date fields in the Table come across as text fields and I have to manually convert the fields to Date fields to...

Roy, Robert, and Neil: Thank you for your input. I will explore each suggestion and get back to you with the results.

BanditWk:I hope I'm not repeating myself, but my response to your response doesn't seem to have posted. In a nutshell... I use to use what you suggested and found it slowed the operation of the database and getting all the users to cooperate and log off (amazing how intelligence functions at...

I have a split database with the backend on a server and the front end loaded on everyones "C" drive linking to the Tables in the backend. Also on the server is the development database I use to update the front end. Currently, I have a laborious task of having to email the front end...

Interesting approach using SQL and a TempTable. I do believe there's a simpler methodology down the avenue I’ve already started down, but I’ll play with your idea just to see how it works. Thanks!

I have two reports. One uses a baseline set of dates, the other uses adjusted dates. Both utilize a query that is filtered from a QBF. I use a button on a form for each report that is generated by a macro to include the query as a filter and display the report in PrintPreview. I've treid umteen...

I have an Access97 database that sits on a network that is used by many people simultaneously. Every now and then, a user attempting to open the database gets a message that contains “…file already in use..” and the database won’t open. I’m confused why this happens every now and then?

Terry: Thank you and you're right. I've recently entered into the SQL world after many years in ACCESS. I'm currently in a SQL Server 2000 Programming course at college.

I have a traditional query in SQL Server 2000 with the SELECT, FROM, WHERE, and ORDERBY. However, when I go to add particular conditions like: if (([a certain date field]<=Date()) Then ([a certain date field]=([another date field]+[a time duration field])); However, I just can't seem to get the...