Hello, trying to do a simple query but it is not working. I have a table Last_Date with 1 value in it. I am trying to use the value from Table Last_Date in...

Hi! I'm using the below SQL statement to create a crosstab query. It works great ... except I need the Pivot "part" to group the compelted dates by Week...

Hello, Got a little problem with a query. I have 2 tables that are linked. The table one is used has a filter for a complex multiple table query that start...

Hi, Can anyone teach me how to run a "make table query " everytime when I open up a form

I have a list of company names, all quite long. I need to break up each record into 2 cells at no further than the 35th position, including spaces. Basically,...

Hi I have a microsoft excel table that is linked to my access database. I have then written a very simple query that runs upon a users request by the form of...

Dear bilingual people, I'm trying to use Access 2000 as a front end to SQL2000, using ODBC linked tables. I have written a query that works fine directly in...

I received this error when I ran a query. How do I increase the space allowed on the temporary disk?

I have a table that has all of our truck numbers, the date of maintenance and the amount of the invoice. I am trying to creat a query that shows the...

could someone give me assistance with this query? I need to select records from a table where FIELD A in REC 1 is equivalent to FIELD b in REC2. If fields...

Hello, I have a table I'd like to append to a second table. Each table has two columns, the names of which are the same. And the data types of the columns in...

Hello, Is there any way to remove specific characters from a text string using a query? I don't want to use the find and replace feature because the process...

Can I get confirmation that an SQL Passthru query will bypass the jet engine. I'm having performance issues and I think it is because the query in question...

I have two tables: CUSTOMER_TRANSACTION customer_id (CHAR) transation_id (CHAR - random, not sequencial) customer_transaction_count (INTEGER - sequencial for...

I want to perform a search between a given date to see what categories were used and then do a compare to the category table to see which categories were NOT...

I just want unique names returned and drop one if two name are the same ?

In a module I have a Sub called generateSCHConFile(). I create a string with the query. Then I call CurrentDb.Execute string. I get the following...

I am trying to create a query that adds two week days to a date. I have tried to use DateAdd("w", 2, ) in my query, but this simply adds two calendar days. Is...

I'm trying to create a parameter query using the date only part of a date/time field as the parameter. Can someone help?

I get an error when I try to create a combo box from the wizard. I am trying to use a database template of the Address book and wanted to look up a person by...