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

I'm trying to build an Access form to select some Crews for an Area from a list of Crews belonging to a Branch. Table layout is shown below. I'm hoping to...

I'm looking for a query that will compare a range of dates, but a little bit more than that as well... Using and in the query... if and are both given, I...

Hi all, I want to display a query result which contains many rows of text (a paragraph). I have tried to use text box. However, I found that there is...

Hi folks - I'm trying to insert a row into an Access table using the following: INSERT INTO Files (FileID, FileName, FilePath, FileType, FileSize, DiskID)...

Does anyone know how to limit total figures for a crosstab, either in at the query stage or within the report? Basically, I only want my crosstab query to...

The simplest way to do this is just to set the OrderBy property of your form to the name of a field. Remember to set OrderByOn as well. This kind of...

I have a query that creates a scorecard and sorts the results in desending order. I would like to assign a ranking based on the results. Below is an exmple...

I have a query that gets its criteria from a form. This query is complicated in the fact that it draws part of its information from a crosstab query. Because...

How would I find the second to last event per person in a table that has dates, events and names. In other words I'm trying to group by name, and instead of...

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 I'd like to know if there is something similar to Sql Server function soundex() in Access ?

If I create a query in an Access Project, (with the datasource in SQL 2000), and I prompt for a time range, (start and end time), it returns zero rows. If,...

I have a rather large union query I build through code, then I *wanted* to use the SQL string as the record source for a display form. I ran into a problem...

I currently have linked tables to an Oracle database. I have altered the table and refreshed the link using the Linked Table Manager utility in Access. After...

Hello All I have two queries that work OK. They each calculate a particular value ( in the first query, and in the second) for each in table (using certain...

I can't see anything wrong with the following StrSQL string but I get this error: Run-time error "3134': Syntax error in INSERT INTO statement. Here's the...

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

In the query builder, use one copy of your orders table, and four copies of your employees table (add the table four times). then link each of the four copies...

Here is my basic IIf function that I'm using. q05z: IIf(Mid(,1,2)=1,"01"," ") It's looking at the first 2 spaces and if it's equal to 1 then it puts "01",...