Queries

update blank fields
Hi, I have two imported tables. Table1: CSPC Toolset Month B3851 AB3851 4/1/2008 B3853 AB3851 B4852 AB4852 4/10/2008 B4853 AB4852 Table2 : CSPC Toolset Month B3851 AB3851 4/1/2008 B4852 AB4852 4/10/2008 I need to update ... 10 Jul 2008 07:13

Filtering by week
Hello! I have a form with a subform showing orders. Each post have a date (loadingdate). In the mainform I have a Textbox called "tbxWeek" and a commandbutton "cmdWeek". When I write a weeknumber and press the commandbutton I want the subform to only show the orders for the given week. The subform is sh... 7 Jul 2008 18:41

Update/Append Query
Am I able to do this within a single query? ... 7 Jul 2008 02:16

Create Update Query
I have a number of text files that I have linked to within MS Access. I need to combine these files into one. All files have the same number of columns and column names. How do I do this? I have started to create an Update Query with all the source tables in the query design window. I have the fields of th... 7 Jul 2008 03:17

Left Join Question
I use Access 2003 and a database with the following tables Table named Employees with the following fields: Payroll ID (this is not an AutoNumber field), Surname, First Name, Middle Name, Start Date, Days in First Period Table named Pay Periods with the following fields: Period ID (AutoNumber field), Peri... 7 Jul 2008 22:47

Querry with User Input and Search the columns
I want to get the user input and use that string to search if it occurs in any part of three columns in the table. For example, Select ID, Survey_01, Survey_02, Survey_03, ([Enter SurveyNum to be searched]) As FindSurveyNum Where Instr(Survey_01, FindSurveyNum) > 0 OR Instr(Survey_02, FindSurveyNum) > 0 OR ... 7 Jul 2008 08:23

How to count a value in a field
Access 2003 I am trying to run a query for a report. One of the fields I need to report on is an "Option" field with 3 options. How can I get a count of all of each Option? There are several other fields on in the query with criteria Thanks in advance, dave ... 6 Jul 2008 21:10

Query to show ALL
Access 2003 I have a form with several drop downs for the user to use to "filter" for a report. in the criteria of the query I have done this: Forms!frmReports.txtSite this seems to work fine HOWEVER If they do not make a selection (the drop down is blank) I want the results of the query to be for ALL c... 6 Jul 2008 18:06

if statement results
How can I make an "if" statement return an empty cell? (Not just a ""). A chart based on those cells keeps giving me zero values ... 6 Jul 2008 14:00

Challenging Date Query help needed
I have the following query that displays total distances for each year of my riding statistics. It works correctly. What I would like to do is change it to show the statistics for each year up to and including the date the user runs the query. I have tried using <=Today(). That and all other attempts have faile... 6 Jul 2008 16:03