Queries

No data returned from query
I can't seem to figure out why this query will not return any data. SELECT AsiaContracts.AsiaContractShipper, AsiaContracts.AsiaContractShipLine, AsiaContracts.AsiaContractNumber, OceanFreightRate.OceanFreigthRateOriginPort, OceanFreightRate.OceanFreightRateDischargePort, OceanFreightRate. OceanFreightCharge, Oce... 18 May 2010 14:48

Use Schedule Task to run Updates, but bypass User-Level Security
I am trying to run a scheduled task to run a macro with updates, but have to enter my Password as soon as Access opens, is there a way around this so it can be ran while i'm away? The only place I see to enter in the actual Task is for the Windows Login itself. Help please!!! Thank you!! -- Amanda ... 18 May 2010 11:28

Min/Max Dates and Group By
I have a small table of data: Start End Appointment Date 11-Sep-09 26-Feb-10 26-Apr-10 10-Jun-09 12-Mar-10 10-Jun-09 26-Apr-10 10-Jun-09 12-Nov-09 11-Sep-09 10-Jun-09 12-Nov-09 12-Nov-09 06-May-10 06-May-10 I am tring to find the maximum date for each combination of start/stop. Applying a max f... 18 May 2010 11:28

Cumulative totals
Hi everyone, I would like to create cumulative totals per month to create a chart. I have got this far: SELECT Data.Region, Data.[Month Year], Count(Data.[Month Year]) AS [CountOfMonth Year] FROM Data GROUP BY Data.Region, Data.[Month Year] HAVING (((Data.Region)="Leicester" Or (Data.Region)="Nottingham" Or (D... 24 May 2010 06:53

Averaging Hourly Data
I have a lot of weather data for one month that is broken down by the minute. My end goal is to take the average hourly value of the column values (temp, humidity, etc.) and create one hourly averaged data point for each column. So, I am having trouble averaging integer values that occur multiple times within... 18 May 2010 15:54

Multiple table query displays only one record
I have a table the has information about grant applications. I have another table that has the names and addresses of the schools related to the applications. When I do a querry it either shows only one record or all of the information form one or the other depending on whetner I click 2 or 3 in the properties wind... 18 May 2010 14:48

UPDATE records by copying from same table?
Hi, I have a table with new records added, that is some information has been pre-filled. Say I have 3 new records with the same reference code ZZZZZZ - they all have unique auto numbered lines. Say for example ID Cust_ID FirstName LastName .............. 1234 ZZZZZZ Fred Jones ........ 1235 ... 19 May 2010 11:35

Convert text to Combo
Hi, I have some 20,000 entires populating a text filed that ideally should be a combo box. I'm looking for the best way forwards with this and wonder if there is any alternatives for what I need to do. The data in the text field needs to be restricted to a small number of options, I'm thinking that I need a ... 17 May 2010 23:29

Multiple criteria IIF function help
Hello, I am trying to create an IIF query field where if RtgGrp not equal NA or Non, the return Yes, otherwise return No. But it is not working. What is wrong with the formula? Thanks NoNONV?: IIf([RtgGrp]<>"NA" or "Non","Yes","No") ... 17 May 2010 13:33

Slow Join
I'm trying to rewrite queries for better performance and am stuck on one. This is how it is written now: SELECT tbl_OrderParts.UniqueID, tbl_OrderParts.Part_Number, tbl_OrderParts.Sales_Order, tbl_parts.Product_Description, tbl_parts.ECCN, tbl_parts.Manufacturer_ID, tbl_manufacturer.Manufacturer FROM tbl_manuf... 17 May 2010 13:33