need help to fix the SQL querry. this querry shows perticular inventory of a specified month and year. the result it shows is also correct. but the problem...

I have a search form with a number of parameters eg. last name, id number, age(selected from a combo box). On the same form, I have a list box in which i want...

Tendo as datas 01-01-2008 e 15-01-2006, como determinoa diferença em meses ?

Hello, I have a table that has, among other things, "as-of date" and "balance". I want to have a running percentage change added to the table. Example of...

Hi, I have a database of investment transactions. Each transaction shows a date that the investment was bought and the date that the investment was sold. ...

I am trying to create a Cutting Tool Lookup Screen that prompts the user For first the Tool Name and then the number of tools desired. This second...

Hello, I am trying to create a update qry that if the value in tbl ITEM is null update from table SUB on Field Description. So far I have.. Field:...

Hello, I have a complex question. I have started the process of this solution by creating the basic query: SELECT DISTINCT tblCustomer.area, ( & " " & & "...

I am attempting to generate a query using two tables that have multiple relationships. When I run the query, I know I should get some results, but don't get...

Good morning. I have a list of model numbers in which some start with letters and some start with numbers. For example, I...

Hello, I'm not sure I named the subject correctly, but here is what I'm trying to do. I have a table with 3 fields. Fields are Style, Part, Quantity. For...

I need some help on figuring out how to merge to fields into one in a query. I have a table with an employee number, last name, first name, etc and i'd like...

Is it possible to create a query to pull transactional data by month stored in rows and create a result that shows the transactional data in columns? ...

Hi all...first post in about a year, but you all (on other access ngs) were so helpful last time I couldn't imagine not asking for help again! I am trying to...

Hi, Sorry if the subject is confusing, doesn't make sense, or just makes me look stupid. I've been learning Access on my own at work, and I need to...

Hi, Here is my query: INSERT INTO CartWeight ( WeightTotal, CartIDNumber, CartNumber ) SELECT Sum((+++++++++++)) AS Expr1, Cart.CartID, Cart.CartNumber FROM...

Hello, I have a question about running totals Have a table that has mixed inforation. I have the sum query for the table with 12 columns, how do I transferred...

Hi, Is there a way in Access to be able to prompt for the table name that you would like to run a query against? What I'm trying to do is to create one query...

In the office I work we do all of our access data entry and updates through query tables, within access. And can have up to 9 people using access at once, not...

Hello All, I am not sure where even to began to start on this query. I am looking for a query that on table tblmaxdata that has the following fields (PN,...