I have a looped VBA function that I'd like to replace with a query.
Basically it is a yeast generation counter for a brewery. The yeast from one
fermentation is used for the next one, starting from a fresh pitch
occasionally (generation 0).

Tables ProjectAmount & ProjectBid both have Project ID in common, and both
tables can have many of these.
I need the SUM(ProjectAmount.Amount) for any related Project_ID in
ProjectBid WHERE Sum(ProjectBid.Awarded_Type) = 0.

I can not sorting data in the program microsoft access for languge right to
left .

I need to make a DB with relationships so that I can compare results of a
test with the real answers and other people and work out the averages of
each section (e.g. Math, Spelling, Reading) how do I do this
Thanks In Advance

I have a query that works, but I would like to know:
A. why it works
B. is there a better way
(Invoice_Number and Line = unique identifier.)

I import from another program the prestations of our workers, i have to add
up the duration.
In Excel i can use the custom format [h]:mm. Is there in Access a similar
function i can use?

I am using a form to gather information which is used to perform a query.
Up until now I have placed the information in textboxes, and then referred
to the textbox in the criteria section of the query. eg.
Between [Forms]![fdlgReportsByModelAndDate]![txtBeginningDate] And

I use MSAccess 2002.
I have a table with the following columns:
Part        Description            Price                Form Button (Memo type)
In the Form Button Memo I have the following code:

Has something changed in Access 2003 using "Like" in criteria of a query that
feeds a Word MailMerge document?  I have several queries that use, for
example,
Like "CPS*"

Does anyone know how to handle keys with mixed case ? ...
I have an alphanumeric [AccountNo] key that uses mixed case, such that the
field values are supposed to be differentiated by case as well.  For example,
the following two records have similar keys except for the case of the ...

I have two tables which look something like this:
tblProd
prodID - Key
prodName

Ok I swear I've read and tried previous posts on this topic but I'm still
stumped.
It should be simple but...
I have a form based on a query: [ReportingQuery].   Within this form I have

I am starting a second query, and the data I am using is my first query which
contains 15 fields.  I have a column that is labeled years in this query.  I
want to creat a statement so when the number of years is between 0-1 it shows
0, when its between 1-2 it shows 1, when it is ...

I'm running a query to tell me the total number of days which is Sum((DateDiff("d",[ddate],[return_date])))
how can i limit the answer to calculate just past 30 days, 60 days and not the total number of days

Hello..I made a query that produces a cumulative column. Than
calculated the commission of the running totals. My query to calculat
the running totals looks like that:
SELECT Turnoversumpermonth.Year, Turnoversumpermonth.Month