My dept has a table with colums like this
TaskNo,Owner,Desc,DueDate etc.....then  Jan,Feb,Mar,Apr,May,Jun,July.....
we each have our own query filtered on owner and each month we bring in the
correct month and mark our task as completed when were are done under the

I have a table that has a Date & Weekday Field and I need the get the Date
Order in Month.  See example Below:
LockDown Date          WeekDay             DateOrderInMonth
7/25/07                      WED                          4 (Means 4th Wed

Hello, I am trying to update a memo field with a SQL query dynamically. This
query is a PL/SQL query whose syntax will be alien to Jet engine. I am not
able to do that as MS access gives syntax error as it reads the text
containing query as executable statment and not as a text.

Im hoping this can be done...I thank you in advance for your
attention...
We keep track on our database of dates that companies are working in
our state... if they go over 180 days in a calender year, they need a

I have a query that selects about 10 fields, one of which is called
CODE.  The value I'm looking for is where code = AAAA.  (this is an
example..)  I get a return of 100 records or so.  Now I want to flip
this and return those records that do not have a code that equals to

I have a query feeding a form from only one table.
The table has duplicates in one of the fields. (the records are not
duplcated - just this one field).
How can I set the criteria in the query that feeds the form to NOT show

Is there a way i can "link" fields in my form? I have a form with Operator,
LeaseName, Vendor, Rig, Parish, TDdate. What I need is when i enter LeaseName
- Cromer #10 then in the others it knows to put in the Vendor, Rig, Parish,
etc... is that possible?

Hello learned guru's, boffins and hackers,
I have a perplexing problem.
The object of the exercise is to transpose the fields of one record into a
listbox. Using a UNION query I am able to get two SELECT queries into the

I have the following query built. I had to add the , between the " " so that
the city and state get properly displayed. Is there a way to use an IF query
to say that if there is not data then just to leave it blank??
HAd3: [HCity] & ", " & [HState] & " " & [HZip]

I have a table with a date field that have some registries with #Num!
When I create a simple query all registries listed in the table as #Num! are
listed as "" (blank) on my query.
Now I need to to check if this field is "" then bla bla... I'm using the

In Access 2000, what expression could I use in a query in order to select
everything to the left of a special symbol (the forward slash: /) from a text
field, please?

I have been using a Union Query to combine multiple tables with identical
fields.  In a visual sense, I have "stacked" many tables on top of each
other.  However, I got to a certain point where I had apparently added too
many SELECT statements to my query and recieved an error ...

I have a tblWarranties containing multiple entries for each customer. I
would like to return a record set of only the oldest ExpDate(s) for each
customer. It is possible that a customer would have multiple warranties with
the same ExpDate, so I would want all.

I import an Excel file into a table, which properly formats negative values
with a minus sign in front of the number.  However, when I run the query,
based only on the table, the negative number is transposed to a positive
number.   Thus, my report gives the wrong sum of the ...

In a query I have a field that calculates the age.
Age: IIf([CloseDt] Is Not Null,"CLOSED",(Date()-([BCBSreceived])))
I need to shows these in Decending, I assume it's a format issue, because it
returns: