I have a linked Excel sheet that I run this query against, however; I
need to narrow the data down by the date also. It is a date/time stamp.
I have tried Format(fix(...., and other date configurations and it
returns no data...

This query always ran perfectly. Out of the blue, it I started getting this
error...it is on the query field    RptDate: ([DateStart]). I retyped it and
now I get data in the query, but the report doesn't want to work anymore. Has
anyone ever seen this before? Thanks! So ...

I have a datebase where im trying to display employees who have taken consecutive Vacation time.(3 or more days). The table has the below data(emplyee ID, Name, Startdate, Enddate). Im thinking I may have to write a function, but would like to keep it as a query
Data:
1,Jon Jones, ...

I need an update query written. Are there any takers?  It looks hard, but I
don't think an experienced query writer will have any problems with it..  Am
I wrong?  I will be happy to send some money to the taker for this query via
PayPal.  Please help me.

Got a small problem, I have a datebase for UK contacts with UK
postcodes.
eg: "GU35 9LW"
As the first two letters indicates an area, I want to be able to use a

I have a scheduler application, and with it a "task board" for my crew.  
Recently I added a bunch of "Daily" tasks to our tracking and they clutter up
the task board.  So I'd like to allow the users to view 1) all tasks, 2) just
the daily tasks, 3) all but the daily tasks.  This ...

I have a field that I want to count the number of times there is a
semicolon.  I there anyway I can can do this in a query using sql?  I
don't think it is possible but you never know.  Thanks

I have a calculated value, AGE based on the following standard formula;
Age:
DateDiff("yyyy",[birthdt],Now())+Int(Format(Now(),"mmdd")<Format([birthdt],"mmdd"))
I am currently selecting this in a query, but what I would really like

I have two tables, Contacts, and Tests.  I want to be able to compare
the actual test scores of students, located in Contacts, with the
earliest preptest scores of the same student in Tests in order to
determine the score increase.

I am trying to set up a new update query. However it keeps asking me for a
parameter in the name field. I have never had this problem before. Needless
to say it is not updating.

Is there a way to show the dates between Two dates excluding weekends and
holidays?
I have a function that gives me the number of days. But would like to see
the days as dates.

I have an append query. If it finds a record already I want it to override.
It appears to just ignor. How do I override in my Append Query?

I get an invalid argument msg in make table query but not in select query
using exactly the  same query.

I am having a problem with an append query, looking for a little help.
I have a table that holds names of people and some other info.  Each
person has a code, which is the primary key for this table.  I have a
delete query set up that will delete the information if I want to take

I have a main table that I need to add information from another table.  There
is a common field in both tables and I want to update a field name in the
main file from the other table. i.e.
common field:  Ven_id