hi all, I need to calculate the number of months in between 2 dates and want to display as "x months and y days" format. I tried using datediff, but it gives...

Is there a way to dynamically run a query (or a series of queries) based on the results of a single query? I believe I need to be able to run a hierarchical...

Hi all I wanted to ask about how queries are executed in Access. Let's say you design a query which itself contains two queries each linked through a...

Hello, I am hopping someone will help me with this. I have three columns in my query LakeID, GR5, AREA. The LakeID is a number that identifies a lake. Within...

Hi, Can someone tell me if there is a date restrictor for the current quarter. For instance, this would be 10/1 through 12/31 but would change after the...

I have a query that summarizes closed cases by customer rep for each week. The results of the query have the data in this format: CR Name; Week Of;...

welcome every body i create a programme that when the users select their names from a combolist a macro reade the time of selection then a report is printed...

Hi, I have a list of value in the format of "Value1,Value2,Value3..." I will need an access sql query to add this to a table. For example if the table was...

I have a query that has a service field with A, S, and W. I have excluded W by "W" on the design view of the query. When I run the query, it displays all...

I am trying to create a query that will show data for the the previous 7 days, but not the current day.

I have an Access table (Access 2000) that contains phonelogs. These logs are compiled with Date (dd/mm/yyyy), Time of Day (hh:mm:ss), Start of conversation...

I have a table with the following fields that tracks the date an inspection was requested/booked for each field respectively(formated in Medium Date)...

I use current versions of Access to staisfy corporate financial research projects daily. It would be a huge benefit if Access had the ability to print a...

I'm using Access 2002 and whne I try to start a new Query the 'New' box is greyed out. how do I get this option enabled? Thanks.

Say I have a table with 12 fields, named color1 through color12. Each field has the name of a color, and there can be duplicates. So, if you were to view the...

Hi, I have a table that holds data from a survey that was completed by employees in our firm. The survey mainly consisted of True/False...

Hi, I am getting the COM error 0x80004005 (Microsoft OLE DB Provider for ODBC Drivers) when I try to do a simple select query via OleDb in ADO.NET on...

I have printed from Access Query database for the last 10 years with no problem. Now, all of a sudden, the gridlines will not show, even though I have...

Hello, Is it possible to write triggers in access(any version)? reply solicited.. Thanks

hello all, I have a SP that returns a nice result set when I run it in query analyzer however if I launch the report wizard in an adp and select all the...