I get a text file and link it to a Access table. I then transfer it to
another table with a text field that is a date and data is in this format:
091105. I run a query to add forward slashes:
Left$([date],2) & "/" & Mid$([date],3,2) & "/" & Right$([date],2)

 I set up a parameter query that asks the user for a serial number and then
it displays the record matching that number. But if the number doesnt exist
it shows me a blank screen. Is there a way to have it say the information was
not found?

I am trying to run a query using: Between [high date] and [low date] formula.
The dates I entered are in Data Type Text instead of Date/Time because
sometimes I need to enter text instead of dates.  But when I run my query it
gives me the wrong output.  How can I still use Data ...

I am working in Access 2000, and I posted a similar question a while back,
but was unable to make this work.  I would like to set up a cross tab query
that will calculate the monthly total of our product in stock.  The select
query that I have created takes information from ...

Here is part of my database:
tblStudents: StudentID
tblStudentsAndMajors: StudentID, MajorID
tblMajors: MajorID

I have a query where I want the variance between amount fields in two
different tables. It calculateds the variance if both fields have values but
not when one of the fields are empty. I have created one of the tables I am
using from a query that summarized the values in one line ...

Hello advisors.
I want to create a parameter query with my start date as any date possible
and my end date being today.  I don't want the user to have to put in
today's date.  How does one format "today"?

I have a table with 3 date fields in it.  I want to pull the earliest date
out of all three fields and put it in a field in a query.
example.  Fields -CertExpDate1,CertExpDate2,CertExpDate3
Is there an easy function to do this?

I am getting all fields from a table displayed in a query even thogh I have
selected only a couple. How do I display only the fields wanted?

I want to incorporate a message "Processing..." for the user when a page is
running a lengthy query.
I don't know how to do it.
I have tried a Response.Write statement but it doesn't print until the

Can anyone tell me what I am doing wrong here?
strsql = "Insert INTO tbltemp (strdriver) SELECT distinct
tblpurchaseorders.[strdriver] FROM tblpurchaseorders where
tblpurchaseorders.[strdriver] like " & Name & "" * ""

I have two tables with a one to many relationship, one table has a single
record with an autonumbered field for Clients, the other table (for delays)
has a many records per client, linked by the same number as on the Client and
also have a unique autonumbered field i.e.

My duplicate records really are duplicates.  Our Oracle Server is returning
multiple instances of the same record when we query it.  (The sys admin
people are working on this <grin>.)
At any rate, what is the best/easiest way to do this?  Is one type of query

I have a net amount that is negative and another amount that is negative.  I
want to know the difference of the two and show that as another amount.  Just
so happens this time - both numbers are negative show on the report the
calculated amount is showing positive.  I need it to ...

In Access97 how can I print the SQL code for a query.  In the Design of the
query, I go to SQL view and all of the code is highlighted, but I do not see
any way to print it directly from there.  I can copy and paste it elsewhere
for printing, but I would think it can be done from ...