Queries

Nested SQL Statements causing slowness and errors
I am working on a query for one of my reports. It takes a percentage of selected diagnoses (and some diagnosis groups). To save the number of queries, I have nested a SQL statement for each diagnosis (diagnosis group). For a single diagnosis, I use the following expression: Primary Dx Schizoaffective Disorder... 2 Jul 2008 13:57

Remove numbers from beginning of social security number
I have a field that contains a social security number. Due to new privacy laws, we can only display the last four positions. I want to replace the first 5 characters with an asterisk, but leave the dashes and last four numbers as is. Can this be done with an update query? 123-45-6789 I want to replace with... 26 Jun 2008 12:34

Query with IF statements and lookups
Hi, I'm trying to write a query and I'm not sure if it's even possible. I have two tables - one with sales data for the whole company and the other with monthly exchange rates for Canadian $ to US $. The problem with the sales table is that the Canada sales are mixed in with the US sales so I need to convert... 30 Jun 2008 18:55

Why do queries automaticly rearange columns?
Why are columns are in a different sequence each time I run certain queries and how can I stop it? ... 30 Jun 2008 11:42

Update query problem
Access 2003 I have two tables which are related by a simple join. The second table contains default values for one of the fields in the first table. I am trying to produce an UPDATE query to set the first table back to the defaults. Here is what I have tried but I get an error message saying 'Operation must u... 27 Jun 2008 08:02

tough one regarding adding two columns :)
Hi I have a table with one row of data and 10 columns that are all total figures of a previous table. example is below: Sum1 sum 2 sum3 2 49 0 etc etc I tried to create a new query to add sum1 together with sum2 to create a new total figure using this: Total of sum1 and sum2: ... 26 Jun 2008 06:23

tough one regarding adding two columns :)
Hi I have a table with one row of data and 10 columns that are all total figures of a previous table. example is below: Sum1 sum 2 sum3 2 49 0 etc etc I tried to create a new query to add sum1 together with sum2 to create a new total figure using this: Total of sum1 and sum2: ... 26 Jun 2008 06:23

tough one regarding adding two columns :)
Hi I have a table with one row of data and 10 columns that are all total figures of a previous table. example is below: Sum1 sum 2 sum3 2 49 0 etc etc I tried to create a new query to add sum1 together with sum2 to create a new total figure using this: Total of sum1 and sum2: ... 26 Jun 2008 10:29

SELECT DISTINCT query is not deduplicating
Hi, I am running a 'SELECT DISTINCT' query that is not deduplicating. I am using Microsoft Access 2000. I have two tables; one is called 'places' and the other is called 'description'. Places has three fields called description, place_no, and place. This is how it looks. place_no place description 26... 26 Jun 2008 10:29

IS this DLOOKUP possible within a query?
I want to create the lookup criteria from a date field withn the query itself but can't get it to work. The lookup I'm using always returns 1 (when it should be 908,1008 etc) DLookUp("WkInd","tblWeekNum",(Format([AK_DELIV_DATE],"wwyy"))) Is it possible to do the lookup this way and, if so, can you please tel... 26 Jun 2008 06:23