I have tried several Data functions to determine how to count the
total number of "Thursday's" in a given month. For instance:
If I choose to find out how many "Thursday's" are in the month of
September in any given year, how can I find this within a query by not

i have two tables i need to compare. One of them has over 300,000 lines of
data. The first table that I need to use for the base has a column named
OWNER and its contents: JSMITH22. The second table that I need to compare
this one to has the OWNER column but its contents are: ...

what is the function to countif in MS Access? To clarify I would like to
count grades and break them out like 4 ..5's or 3 ...2's etc

I am trying to join 2 tables.  I want to join if 'Field B' is in 'Field A'.
ie.
Field A = 'ABCDE'
Field B= 'BC'

Is it possible, do you think, to insert a combo box into the criteria
section of a query? The user of the query will have a lot of units to
choose from in the query and it would be easier for the user to have a
drop down box to make a selection from. Can this be inserted into the

Hi I am going to illustrate what i am trying to do in an example. I have the
following results from a query:
Payment#   Account #        Payment Date       Payment Amount
 1                1000                4/2/2007              $500

It was easy in access 2003
Much obliged
dennist

I have Employees Table with 9 employee record already in the table i want to
insert a new Employee record in the table with INSERT INTO the primary key is
AutoNumber and i'm inserting from a form. How should i create this becuse i'm
getting error on this ? I'm using the Northwind ...

I am having trouble in designing a query to prompt user input via wildcards.
How do I go about making this happen. For example: I promt the user by asking
[Input Item number], the user then inputs any item number and the item number
appears in front of him as a record on a form. ...

Hi, I am new to forum posts, but have reached last resort, - have flat spot
in my head from beating on brick wall!  LOL.
Need to build a query ( I think)  for a database and cant work it out!
Scenerio.

need help to get a cv template downloaded free?

Hello...
I am struggling with a query to do the following...
From a table tblData like this:
ID  Vehicle   Date            Ref    Cost

How many levels can you have to an IIf statment? I know Excel you can only go
seven of eight levels down. I have the following statment and I need to add
one more for 1000 - 1400. When I add it I receive a too complex message. Any
suggestions on simplifying this would be much ...

Hello, I was wondering if anyone could help me with something.
I currently have a table with stock levels and a re-order level.  When the
stock level gets below the re-order level I then contact the supplier and
order new stock.

I have a table in Access 2003 that contains several numeric fields, lets call
them aa, bb, cc, and dd.  Is it possible to create a select query, based on
this table, which contains a calculated field that sums the content of *only*
those fields aa, bb, cc, dd that I pull into the ...