I have field name 'month' in 'Table1' and the data in 'Table1' like this;
Sep 2005
Oct 2004
Nov 2005

I'm not sure if this question if a query question or a form question.
I have 2 forms, each based on a different query.  Both prompt for input when
opened.
- On one if you don't input anything you get a blank form.

I need to calculate an appropriate mean and variance when there are "missing"
data.  Let me explain with a dataset from some fisheries sampling we
conducted:
I have two tables and a one to many relationship.

I currently have the following in my select query but I want to be able to
select a year as well. How would I incorporate that into my query? This is
what I have in there so far:
Between DateSerial(Year(Date()),[Enter Starting Month],1) And

I have a table that has a field (org) that has data like
AA-2
AA-2
AA-2

Is it possible to use VB Code to modify the SQL Statement in a Query?

OK...I give up!  I have a report switchboard with two unbound text boxes name
StartDate and EndDate which are to filter the reports by date.  In the report
queries in the Date field I have the expression:  Between
[Forms]![ReportSwitchboard]![StartDate] And

I'm attempting to write a formula stating that if a loan is a refinance, add
3 business days to the close date, if not, use the close date.  Can someone
help me?

I have a query that has multiple fields.
I want to select "*electr*" as criteria for two seperate fields in the
query.  What I hope for is for records to show up with *electr* in one
or both of the fields.  Instead none of the records are showing up.

I am an Access newbie.  Simple queries I can handle. But, I have been tasked
to create query where I compare two columns of dates and get an output of
day(s) difference between the two.  This is with the intent to clean up our
data as best we can.

I have the following "find duplicates" query that returns the records with
the maximum value in the NPIEC field.  What I need instead is for the query
to return the records with all BUT the maximum value.  Min won't work because
I could have 3 records containing duplicates.  If I ...

I am new to Access so this may be easy. I have a query with the following
expression, Remaining Containers: GetRemainingContainers([EAIID]) and I want
to multiply this column by a concentration column so here is what I did.
Expr1: [Remaining Containers: ...

I created a macro that will run several delete queries at once.  Since I'm
deleting from several different tables, there are several warning messages
that pop up asking the user if they are sure they want to perform the action.
Is there a way to remove these messages?

How to delete a template or batch entered but unposted, to be deleted from
solomon journal transaction

I am getting the following error:
Run-time error ‘13’:
Type mismatch
My code that I am running is: