What criteria do I put in the append query so that I will append only the
data with the ProdOrd (text field: 000123456) the that are NOT currently on
the appended table named ProdOrderWIP. Thanks

I have a table with fields f1, f2, f3, name1, name2, name3, name4, f4, f5.
I need the table to look like f1, f2, f3, name, f4, f5 where it would list
the
name1-name4 in rows instead of columns. (ie reverse crosstab).

I have two tables. I want to insert all the columns from table 1 into table
2. then sort table 2 to have a 'pageID' field combine by matching numbers
properly. That will infact make the database made id index mixed up. so how
would I reindex the id field. At the end, how would I ...

I have a table called A028 CMF2. In that table I have a fields called Job#,
Sub Task and Fee Pct.
An amount for the Fee Pct comes over from another system but it is only on a
Job#'s main task. I need that Fee Pct to be copied on to the Job#'s Sub Task.

I bring data down from our school database into Excel then import into Access
then query to give me students that increase their grade 1 whole grade , then
export back to Excel to run a pivottable that does a running total column
then link it back into Access to take where a ...

Using the following table data:
TableName = ClaimsHistory
PrimaryKey          ClaimID
       1                        1

Can sombody please help me, I saw the code below in another discussion group.
I wan´t use it but with more categories. how can i make it work?
I would like to have it like this.
1 Female 8-11

Dear friends,
I have a table with the following columns:
Code#, OrdDt, Quantity, amount, Salesrep, Customer,
I want to form a query to show the following:

I just learn that Dcount is slower than select count(*) from my table.
Does it mean that we need to use SQL every where in the applications?
Are there any rules to when to use which one?
Your information is great appreciated,

Please help me create SQL statement.
I would like to INSERT values INTO MemberKey field for tblUSER_PA table that
correspond to the same value MemberKey field from the SU_People table.
Both tblUSER_PA and SU_People tables have same User_Cd field which they can

I posted this earlier in Programming without response.  So I thought I'd try
here.
I'm reverting back to Access 97 and running into a problem with the app and
the use of CurrentDB.OpenRecordset.  

I have a table called tbl_status.  In this table there are 7 fields.  
status_id             Autonumber
lif_id                    Number
status                 Text

I have to two tables with field that match for the most part, but I have
fields that may not have a value in the table to match and visa versa.  I
want to build a query that displays all the values that have values in both
tables and those that have a value in one or the other ...

I research this one but could not find an answer.  I have a field called
FiscalMonth that has the name of the month (ie February, March) as values.  I
want to run a query that captures the current month using this field.  What
would I put in the criteria expression to capture ...

I have tried several different ways to get this to come out but seem to have
a syntax problem in Access 2000
These are my two best shots neither of which work, I can't even get out of
the design window. I'm sure I'm missing something simple