Hello Please I have a question. I am using access 2002. I created an XY (scatter) pivot chart in access. I need to add a backdrop to the chart. The problem is...

Hi All, As usual, I'm stuck with another problem that I can't solve. I have a table called MainTable (see below): MainTable: Loan RevDate 1234 ...

I've got a table I'm trying to update with data from another table. The table to be updated has multiple columns but I'm concerned with two: DEPT ...

My hunch is this question will make clear at least one basic concept of Access 2000 that is escaping me, but I'll put vanity behind. Besides, maybe if I get...

I have a "daisy chain" process that runs several queries, eventually culminating in two crosstab queries. One of them contains summarized data for each of...

Hi, I have 2 tables each having 3 fields - Product Name, Version and Qty...but the Products are not the same. I need to Subtract Table 1 from Table 2...

Context: Access 2003, MDB file Setup: I have a query defined (schematically) as "SubqueryA LEFT JOIN SubqueryB". The query returns some rows from SubqueryA...

How would I run a parameter query that prompts you to type the first couple letters of a last name, and will allow the entire name to be retrieved?

I have a select query as one of the steps in a macro I'm running. How do I get the select query to not show the datasheet after it runs?

I need to do the following: Set up tables that have validation Use Append query to add data to the tables. I know that some of the data will violate the...

I'm trying to create a calculated field (STARS MATCH)in a query using the IIF statment. Examples of the fields and the data in those fields is shown...

I am not sure why I am having so much dificulty right now... I have a table with 3 fields and 200,000 records. Fields are Supplier, Unit, Spend Supplier is...

I am trying to call values in a module based off of calculations in a query. The calculations return double numeric data types such as -.0015 and .0015 my...

I would like to create a query that when run will show the last 30 days without me entering the dates. Is this possible?

Hi, I am using MS Access 2003 and want to store pictures in binary form in the database. Can you please suggest me on how to achieve the desired. Thanks &...

I'm having a problem with an update query; I need to update a date field if it is not a known processing date. 2 tables, 1 has a list of items and the target...

Hi, The query below selects the records existing in Table A which have no matches in Table B. I use this query every month without problem. This month...

I have a table. The table has a little over 200 fields. About half of these fields are filled from check boxes on a form returning a value of 1, 2, or 3...

Hi, i have two text boxes with iif statements, basically both are (iif 0, , " ") then on the difference column where I compare the two costs i tried...

I have used Vlookuo in Excel frequently. I just do not know how to do it in Access. I have two queries: The first query is called Which is query tha is...