Search results for query: *

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...

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...

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?

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...