I searched through the questions and didn’t see one that is similar to the
question in mind.  I have the following in a table:
ID    Project    Completed
1    ABC    No

The  INFORMATION field  stored any things: number, text and Date.
EX: 12/01/07 :Namenda 10 mg.
     9/8/ 06 :Namenda 5 mg.
     Aricept 10 mg.

I have a query that looks like this:
TRANSFORM mytable.var1,Count(mytable.var2) AS cnt
SELECT mytable.var1,  count(mytable.var2) AS TOTAL
FROM mytable

I have part numbers we supply at 2 of our locations. My query contains usage
per quarter and a field that has estimated annual usages. My table will
contain duplicates because the part is at 2 locations. The outcome I want is
to have no duplicate parts, but I want the larger of ...

I have a form with the following controls
Combo30
Value List "> Greater Than";"< Less Than"
Text42

I have a column that gives me the results;
/dir/dir/customer name
I want to filter out the /dir/dir/ so the column results just show the
customer name, I think a substr() might work but I am not sure how the syntax

I have a query that looks like this:
TRANSFORM Count(mytable.var2) AS cnt
SELECT mytable.var1,  count(mytable.var2) AS TOTAL
FROM mytable

Please help me in creating Query form below records:
RecDate    Details    Debit    Credit
01-Jan-07    Sales    2   
03-Jan-07    Sales    3   

I am currently using a query that request a "start date" and an "end date", I
would like to change the request to "Week ending date" and include
information 7 day back. What would I have to change to get this information?

I have this already in place, but I need it to also look at the MotherBaby
Field and if it is checked then  it over rides this and inputs a default of
$2256
Rate: IIf([Age]<=4,1589,IIf([Age] Between 5 And 8,1648,IIf([Age] Between 9

I have this already in place, but I need it to also look at the MotherBaby
Field and if it is checked then  it over rides this and inputs a default of
$2256
Rate: IIf([Age]<=4,1589,IIf([Age] Between 5 And 8,1648,IIf([Age] Between 9

I have a table storing customers (using a 5-digit code as key) and a field
called ORDERS_CAT which stores A,B,C,D,E depending on category of the order.  
Then another field called ORDERS_COUNT showing total count of the order.  
There are many other fields, but these are the ones ...

Been trying to figure this one out for a while in my spare time by
following an example I found in a book but it just isn't working for
me.  I figure if I can ge the first query to run I should be able to
figure the rest out (I hope!).  I created this basic query in Access

I've been working on this query and report for several days now, to no avail.
Any and all suggestions would be extremely grateful for!
First, this query is pulling information from just one table.  The main
thing I'm trying to eventually do is to get a sum for each of the years ...

My DB has an Assignmenet table that captures the date/time a record was
assigned to a team.
Records may be reassigned to other teams once or many times.
How do I create a query that returns the start and end date/time for each