These queries worked but now I need to incorporate ID with the data in these queries. Thanks! ID Product Date Dif Date 1 A 1/23/2009 40 1 ...

Working in MS Access 2007 I created a query and a pivot chart with the option to show the data in more than one chart, but when I choose the multiple chart...

Hi There - I am trying to create a basic query that excludes certain records. My table has a field that is status. This is a lookup value that I created...

I am sure the answer to this is easy but I cant seem to get it. I need to sum a few columns. I have tried using a total query but I dont have anything for it...

I have a mainform with products (and thier details) from a products table and a subform showing ingredients (from an ingredients table). I wish to select...

Ok, If I want to calculate the difference of a date with the following date in Access: so 3/29/08 in cell A1 and 5/3/08 in cell A2 and return the value in B1...

Have 2 queries the names are "CustomersNoSales" and the other "CustomerSales", both have a field named "CID"(CustomerID) and another field named...

I have a query that has a "Job#" field in it. I want to be able to have different criteria for the "Job#" depending on which combox box the user is using...

Hi, I run a query, including (in design view) right clicking and clicking properties and setting format as (tried both indivifually) hh:nn and Short...

I am exporting a query to a .csv file. In a Date field I formatted as so: FormattedActivityDate: Format(,"yyyy/mm/dd") The date in the .csv file shows up in...

Can anyone advise why I am getting a 'Too few parameters - Expected 2' with these two SQL statement? strSQL1 = "UPDATE tbl01_PermSrvcsIgnore, tbl01_Services...

HI ALL! I have a table with following 3 fields: Account_1, Account_2, Amount Any query that would result into following layout? Account (Containing Unique...

I have two tables - Barcodes (fields: Barcode, Event, Callsign, Registration, Type, Operator) and Movements (fields: FltDate, Callsign, STA, STD, ATA,...

Upon creating a simple query requiring a table with following fileds: Field1, Field2, Field3 To be grouped as follows: SELECT Table1.Field1, Table1.Field2,...

Win XP Access 2003 In a select query, I want the criteria to be "Is Not Null" if the parameter is left blank and for the query to not filter on that field. ...

Hi, I have time in a table in 24hr format, then when I run a query on that table it gives time to me in AM/PM format, this is annoying, is there a way for me...

I have a single table with a unique CPT Code field, a Price field and a Department field. Different Departments sometimes charge a different Price for the...

Hi I have a table named tblCostsByYear with data as follows: AccountName Year Value Fuel 2009 ...

Hi Everyone, Using Access 2003. I have my query working....almost. I need to see patients who have been on therapy for more than 10 days. I have a field...

I have a large dataset consisting of start- and endtimes of personel shifts. I'd like to make a query that calculates the number of shifts per time...