I set-up a standard query with one simple right join using the query builder
tool in MS Access.  When I run the query, the fields (note: I am talking
about the fields and NOT the field values) do not display on screen in the
same order that they are in in either the SQL or design ...

I HAVE A LARGE DATA BASE THAT WAS CREATED IN A FORMAT OF THE WHOLE NAME IS IN
ONE CELL I NEED TO SPLIT "JONES, BILL"  WHICH ARE IN ONE CELL INTO TWO CELLS
THANKS IN ADVANCE FOR YOUR HELP
SJW

Hello~
I am attempting to design a query that uses the DCount Function to count the
number of "yes (via a checkbox)" responses to a survey question.  Problem is
I would like to use two criteria and am having difficulties.  Below is the

Query1:
tDate         TrapNo     Species    AmtColl
1/1/2000      E1            TAE         100
1/1/2000      E1            COL         150

I have the following expression in my query: DOB_MM: Format([BIRTH_DT],"mm")
and I have verified that my field, BIRTH_DT is defined as a Date/Time field.
The problem is that I get a compile error on this every time I try to run it.
I have replaced the BIRTH_DT field with DATE() ...

Is it possible to use an if statement in MS Query.  My data base has one
column that stores the dollar amounts and another column that tells me if it
is a debit or credit amount.  I have tried this:  
=if([DORC]='D',[AMT],[AMT]*-1)  Doesn't work.  Is there another way?

I did a query where I want to add on a certain amount of months to a date
depending on the contents of another field.  Here is the statement I used:
SwitchDate: IIf([Active_SPA_summary_02d]![MODALITY]="*PD*",DateAdd("m",30,
[Active_SPA_summary_02d]![MaxOfFIRST_DIALYSIS]),DateAdd("m" ...

hi,
I am trying to get the datecreated for a specific csv file.
I am using the following, but I am unsure of what to do with this or where
to go.  If the file was created on a specific day, then I want to run another

I have a field [DateWeek] that has the following information in it:
Week 1 - 1/1/06
Week 2 - 1/8/06
and so on until Week 52

Have 7 queries that I need to execute in order, with just one click of a
button on a form.  What do I need to do to make this happen?

i have a field which contains a folder name followed by a '/'  follweed by a
filename.  Both the folder and file names are variable lengths
I need to split the data into two fields so that I have the folder and the
name in two fields

I am trying to make a query that returns all records within a specific
time interval. The query targets a Date field containing only a time
i.e. #12/30/1899 TIME#.
WHERE

I've recently run into a problem and after looking at other entries on
the groups entitled "sorting by month/year" or something to that
effect, i find that i'm still at a loss.
my first problem was changing the 15 or so decimal places i had to just

I want to run a query that will bring up records using two date fields.  One
is the service date and the second is next service date.  the criteria i use
for both fields is Between [Forms]![frmReports]![txtdatefrom] And
[Forms]![frmReports]![txtDateTo].  The query doesn't work ...

I hope that some kind soul is able to point me in the right direction.
Currently working on my Access project and have hit a small stumbling block.
What I am attempting to do is to update records in 1 table based on criteria
in another table. So onto the details.