I want my command button & start and stop textboxes to return records within whatever date range is entered. Instead what returns is 1 of 1 record...

Can you explain a little more about your table structure and maybe give some examples of the data? This may not be the most efficient way to do this. My...

I have a table that contains data I'm pulling from our main company database, J.D. Edwards. Unfortunately, I can't find a field in Edwards that defines an...

I am running Access 2003 and have a chart based on a crosstab query. The problem is my x-axis or row heading is showing duplicate values and I can't figure...

The entire error reads as follows: ODBC -- update on a linked table failed Function Sequence Error. (#0) I am trying to run an update query from a linked...

Pls help me..... Is there any code to include in the criteria in a query to search for the item starts for for example:- 862- thanks

I have a Query with many tables. So far I have gotten the results I need just by using the Outer Joins. Now the last step is to compare 2 tables with...

How do I write an Append query that will copy non-duplicated Employee Numbers from one table to another? -- Madelyn

I have 2 fields (Date Created from master table and Review Date from a sub table). All records have a “Date Created� entry. Not all records have a...

Hello, Im just trying to create a temporary table to do some work on it and I want it to be deleted after my work is done (my program exits). Im doing it the...

Many times I use the Query tool to create a query, then I copy the SQL and execute it from VBA. I need to create a make table query to make a table in my...

I have a crosstab query that gives me quarterly results. Right now we are at the end of the secord quarter, so we have no results for the third or fourth...

I am trying to do a comparison between a query and a table. And one of the comparison fields is the Postal Code field. But somehow this is not working the...

I have source data that is definitely only one decimal place in length before being copied and pasted from Excel into Access. When I query the data, the...

cp2599 wrote: On Jun 24, 12:53 pm, MGFoster wrote: cp2599 wrote: I have two tables Individual and Family with two one to many ...

I'm using Access 2007 and I'm trying to take data from a single table and insert that data as multiple new records into three tables with established...

You can use an IN clause to reference a table in an external database, e.g. Dim cmd As ADODB.Command Dim strSQL As String Set cmd = New...

I'm trying to write an Append query to copy Employee numbers from one table to another table. The Source table is left joined to the Destination table. The...

I have a master table of records that include clients and record creation dates. I also have a subtable for documenting yearly review dates, comments etc....

Hello, I am trying to append some records from an Access table into Oracle using an ODBC connection to Oracle. The append action is moving very slowly and I...