Hi I have a data table A with several fields including cust # and part #. I have another table B with cust # and part #. I would like to create a query so...

Hi, I'm sure this one is an easy one, I just can't figure it out. I have created a query looking at one table with Dates and Sales figures. The dates are...

Hi, I am converting from A97 to A2k3. I have a form that allows users to make choices and then hit a button to see results. Behind the scenes I'm making a sql...

I am a newbie so bear with me. I have a database that is set up to track all job by projectid. I created a multiple parameter query to show all the amount...

I have a "text" field with the data such as 02, 02A, 03, 03A, 123, 123B. It can be only two or three digits number with or without A or B. Table1 NumberOf ...

I have a table listing employees with a one-to-many relationship to a table of notes; obviously each employee has many notes associated with him/her. I would...

Hello, I have a crosstab query that when run displays the following error: "Record is too large". It is a large query, I have 235 columns, but as far as I...

I have a query that has a column name accounts. How do I create an expression that will turn "mailroom" and "meeting" in the account column to zero? Floyd

I am trying to create a form that will serve to populate the criteria in a query. I have about 10 fields listed on the form. When I enter a value in the...

I have a Query that is like a Service Bill and I use it for a Report that is a service bill that I want to print out. My query is working fine, but a minor...

I am new to access. I have a database that is too large 2gig, so I set up two databases each with a table that are identical in structure but the data is not...

Hi all, I have a custom function that I am calling from a query. The problem is that this function is then executed 3 times instead of just once. I found the...

I would like to create a delete query based on an appened query. This query takes information from two tables (2 op portfolio and 3 op contracts) and dumps it...

hi could someone please help me with this query i have the following tables: projects, materialsUsed, equipmentUsed and labourUsed. materialsUsed, equip and...

I have a Query that is like a Service Bill and I use it for a Report that is a service bill that I want to print out. My query is working fine, but a minor...

Thank you Query 1 (avilable) ID from to RN NN Total company 1 1/1/2004 ...

Is it possible to use the excel function: LARGE in access 2000. or to write it in vba???

I am trying to get query to return records where PiecesLeft field is greater than 0. When I put 0 in as criteria for PiecesLeft I get a popup box asking for...

I have a report querying a table. It runs very fast with normal selection criteria. However, i now need to further select, searching for a word in a text...

I have queries which contain all of the information on our companies clients. I then have a number of reports which use this information for us to...