I have a table (tbl_Client_Info) with three fields, First_Name,
Middle_Initial, and Last_Name. I also have another field Full_Name.
Once the user (from the form) types in the First Name, etc, I want the
query to get the 3 fields and combine them into one called Full_Name.

Sorry for that empty page.  
I have a form with a subform on it - the subform's data is a datasheet.  I
would like to change the pertinant records in the filtered data on the
datasheet and run an update query that only updates the records in the set

OK, this probably falls into the "you-can't-do-that" category, but it's worth
a shot.
In my db, I am storing periodic 'snapshot' tables.  I want to choose which
table to run my queries from, without needing to go to design view, add the

I have a table with a numeric field.  Some of the fields contain zero values.
For the purpose of calculating an average I want to ignore these fields.  
How do I make them null.

Hello, I apologize if this is a duplicate, can't find my post.
I need a query that will prompt for StartDate and EndDate, where the
StartDate time of day is always 22:00 and the EndDate time of day is always
08:00.  I want to see all records that start *or* end between the ...

I have one table (DATA) with records sorted by date in a YYYY-MM format.  
But there is not a record for every month.  
The second table (MONTHS) is a list of all months in 2005, in the same
YYYY-MM format.

I have a crosstab query that changes in the number of fields that will
populate every time it is used.  Sometimes it is 20 fields, sometimes it is
150 fields.  This causes 2 problems.  First, its not predictable the layout
of the table, and 2nd my next step is to try to concatenate ...

I have a database with a table for children (ChildIDnumber, name, birthday,
etc) and a table called SignUps  (SignUpNumber, ChildIDNumber, Session,
Class, etc.)  They have a one to many relationship: one child can sign up for
many classes.  I would like to query my SignUps table ...

I have two tables
tableA and tableB both have upc data in them however tableB has a "00" in
front of the upc code
I need to see all of tableA and what tableA.upc is like in tableB.upc

I have a lot of queries on linked SQL server tables. One linked table in
particular causes problems for queries if any of the records are in use.
How can I run queries on linked SQL server tables without them crashing when
a record is locked?

How do I create a query to include all the docs from table1 that don't have
matches in table2?
For example:
Table 1

I have parsed a YYYYMMDD field (from an SQL db, via ODBC) to display as
mm/dd/yyyy using a combination of 3 Mid functions and concantenating. It
works fine. I then moved the field to the far left column so it appears at
beginning of record. However, the design window indicates it ...

I coded this query in SQL designer:
SELECT Q.*, D.TargetDate, D.InProgress, D.ActualDate
FROM qryDatesForPkg1 AS Q LEFT JOIN tblPkgDates AS D ON (Q.ID = D.DateTypeID
AND D.PkgID = [Forms]![frmPackages]![PkgID])

i need a query that would help me calculate homany kids are in age range from
1-9 years old

I used this Statement in Access 97 to make table and now after upgrading to
Access 2003 this statement is not working. If I use this as Select query it
works fine  but not with Make table... What am I doing wrong? Thanks in
advance.