I have a column of 5 digit julian dates (ex 08066) that I need to convert to
a calender date. The julian date is formatted as text. I am using access
2003. I have used the following  code but I get only blanks.
Function ConvertJulian(JulianDate As Long) If JulianDate > 40001 Then

I've got my duplicates records query and now I want to delete these 1100
dups in my table of 12,000+ records.
Can you please explain how I can easily delete these duplicate records in my
table now that I have found them in my query.

Following a tip I got from the forum yesterday, I want to find a way to make
it easy to find redundant queries in my database, prior to deleting them.
Because the application is large, I may not find it easy to check each area
one at a time to see it it works after a query has ...

How do you join multiple Select Statements, here is what I would like to join;
SELECT Count(SCD.Status) AS [# Actions Returned]
FROM SCD
WHERE (SCD.Assigned)="Carla" and WHERE (SCD.Status)="returned";

I have a query that I am trying to use to return names and addresses that
match partial(match half or more character)or full to another field. And
maybe i need function to remove the special character from the field (eg:
Comma)

To whom it may confuse. I have a query with a text field that needs to be
sorted in descending order. The field name is "ContainerNumber" and the data
will always have at least a letter in the begining. As you can see the data
sample "D100/07" comes after "D10/07" and that is not ...

I have some several fields that have duplicate Patient_ID and I would like to
count those duplicates and assign them a number for example.
Patient_ID Radiology
123           MRI

I have a table with record.
Each record has an opening date and most records have a closing time.
What I would like is to see a pivot table or chart where I can see per year
and month the ammount of opened records and closed records.

I want to list some specific queries in another query. The queries that I
want are prefixed by a 99 but when put 99 in the criteria of the first column
I get a "data type mismatch in criteria expression" error
any ideas?

I have been wrestling for ages now with a query that I thought would be
simple .. but can't get the output I want!
I have a table [practice suppliers] with fields SUPPLIER and AUTO CATEGORY
(and others). The field SUPPLIER is not a unique (key) field, but in fact it

I have 3 "TYPES" of duplicates. Here is the table:
ID classID Attend_date
1    625       12/13/06
1    292       5/16/006

Basically i have a drop down that i want controlling the Criteria for each
field in my query to have an advanced search. If i leave a field blank the
query comes up with nothing so i tried this:
Code:

I'm not a programmer but have built a database for my business. Data
is entered through the original at my office. I'm am still in the
process of refining it so I take a copy back home and work on it
there. Sometimes it's a few days before I get the modifications done

I hae a query set up to sort all my data into nice little reports. The only
problem is a month from now I don't want to have to print everything just to
get yesterdays report. I would like a query that says only show the records
for date X through Y, and I would like to use a ...

I have a form with about 40 buttons on it, and each one opens a report based
on a query.  What I am trying to do is code the buttons so that there is only
one query and one report (since the format is the same)  that they pull from,
as opposed to 40 different reports and queries ...