I have two fields in a query txttext1 and txttext2 that I would like to
evaluate and based upon the result put a value in txttext3.
What I would like to do is call a function within my Access 2000 query
that would take a value of text1 and a value from text2 and give me a

Please have patience for a true novice here . . . I have read through so many
threads and other suggestions on calculating elapsed time, but still have
some issues.  Specifically, I'm  using a form to automatically calculate &
store "Time Opened" and "Time Closed" for trouble ...

Please excuse me if this is a novice question. I am a bit away from my
confort zone with this as I am using a DAO link to interface with
Matlab.
I want to get values from an mdb file. I am looking to pull whole

I've already got some help for this, got a lot further but still not
working 100%.
I have a customer table that is linked to another table
'tblOrderFormsSent' (one-many) with a record of each time we send an

I am hoping to get further assistance from Michel Walsh about an issue
from Aug 19 (hide duplicates in related records) in the query section. I
realize now that the simple solutions are not working for me. Grouping
records together in the header creates extra rows that I can’t ...

I have been trying to create an update query but I can't get it to run right.
When it does run it updates all of the fields for all records with the same
information from record 1..
I have a table for states and regions ie: Minnesota Central, California

I'm currently updating an application and I'm having a SQL problem
which is getting quite urgent.  It's Access 97 front-end with a SQL
Server 2000 back-end.
As part of this particular update, I need to run an INSERT query

My table looks like this:
recno    sem    sid                    last    first    address
1            3        88-123-4567    Li      Jun    345 Fullerton Road
2            3        88-123-4567    Li      Jun    345 Fullerton Road

I have a query which splits my data up into weeks with the year begining in
January. I have done this using:
DatePart("ww",[EpsEndDate],2,3)
Is there anyway I can get this to run for the financial year - April to

I am trying to formulate a SQL statement to look for values present in one
list but NOT present in another list, almost like the "find unmatched query"
wizard except that the result from the wizard will not show if there are more
values in one list than in anther. Let's say we ...

Hi people, here yet another question about deleting records in a table...
I have a table A with three fields: A_id, A_value1, A_value2. The value
fields might have the same data...
The table would look like similar to the following:

I'm using the count function in a query with qualifying criteria.  In some
cases no records meet the criteria, so no records are created by the query.  
What I need is a record to be created with a zero in the count field.  
Assistance appreciated.  Thx

I have a wildcard date search as follows:
Like "*" & [date] & "*"
I am using it since [date] may be a blank field.  It returns both 20-Jan-04
(*1/20/2004) and 20-Nov-04 (11/20/2004).

I have got a table [PRODUCT] from my principal. I just noticed that there
should be a field 'VENDOR'. So I added up a field VENDOR (TEXT). Some of the
records are related to 'ABC'. Some relates to 'XYZ' and so on. Now I want to
fill this field with 'ABC' where field is blank. I ...

is it possible to compare values in 2 different rows? for example if the
query returns this:
1 | $5.00
2 | $6.00