I have a query that executes a Table-Valued Function in SQL server. If I execute it withing Query Analyzer in SQL server, it completes in 40 seconds. If I...

I am looking for a way to query for the following: *T* The problem is the T is surrounded by an * which is a wild card. It pulls all the records with a T...

I sometimes need to find the largest or smallest value in a field. If I put two indexes on the same field, one in ascending order and one in descending...

A co-worker and I are muddling our way through Access to try and build a report. I do Word, Excel, and VBA, and have tied myself in knots with Access before;...

I have two tables - Employee_PunchTime table and Holidays Table. The PunchTime table contains three fields representing EmployeeID, Time-in and Time-out;...

I have an Update Query that asks for 3 fields with parameters. The first parameter is the criteria in the query to identify which record we are updating. ...

Hello, I would like to see ALL (0 and -1) records if my check box in my form is not checked (0) and if checked (-1) I would like to see only record with -1...

I have a query based on two joined tables and need to know how to insert SQL into existing sQL so my query counts "Assigned Consultant" Properly. if the...

hello i have been trying to export a query to an excel file. this query will run once and the data that it selects i want it to export to excel. then the...

Im trying to build a form with multiple check boxes that each apply a filter to the records displayed. I need for the user to be able to select any...

I am trying to decipher the “status� of records in my table based on two date fields and the name of the agent assigned to each record. The fields are as...

Is there a way to put build a query to accept only the current record from another form? I want to use the autonumber to show only the record showing on the...

I tried to change the field name in a query using "New Name: ". It did not work at all and just display the caption of the Field Name. Is it possible to...

I am using both Word and Access 2003. When I merge a Word Letter with Access, sometimes not all of the queries show up, in the drop down box, to link the...

I have created an update query to update a master file. When I run the select query to view the records I need to update - I see the correct data. When I...

I have a call database that includes a field for length of call. I have created a query that includes employee, date, and length of call. I need to calculate...

I am in need of help with exporting queries from Access 03 to Excel. I am familiar with the transfer spreadsheet command using DoCmd.TransferSpreadsheet...

Warning - I am a complete novice to VB. However, I have a situation where the Split function is really needed in a query. I copied the following from the...

Hi Everyone, Does anyone know how to do this? I need to export a series of queries to 1 Excel workbook, with each query being a new tab. I have pretty...

I just converted from A97 to 2002. When a user runs a query, she was able in A97 to do a Filter by Form on the query, and the fields would populate with the...