I’m am using a queryDef to pass some variables to a query.  I am passing
numbers from a combo boxes that have leading zeros.  However, when it passes
it drops the leading zeros.  How can I stop this?
Setup:

I'm having a problem.  When I make a query some of my rows get deleted.  I
think this is happening because there is 0 in some of my fields.  I don't
want it to delete that row I want to see it say 0.  How do I keep my data
from disappearing.  

I am using Access 2000. I have created an Update Query and I want to turn
off the "are you sure" warnings. I have created a macro that runs the Update
query and I have SetWarnings set to "No" in the macro but I still get the
"about to update 297 records" messages. How do I make ...

I am trying to run append queries from my 5 tables that are linked to
another database into 5 tables in my current database.  I filter them from
within a form.  Say I filter by the officer field and I have 30 records.  I
would like to run append and delete queries to accomplish this ...

I have a large database of data, I would like to only display the last week
of this info every week in a query or report?

Hi
If anyone can help me with this I will REALLY appreciate it!!!
I have two tables:
Orderline_subform which contains(orderNo, orderlineNo, stockNo, quantityOrd)

Is there a clever way to speed up query execution? I would like to
create a query that lists activities with the following rule: if no
activity per day, leave blank; if multiple activities per
day, show first.

I am running reports by using the query by form technique.  I have two text
boxes for date range and it works well when I enter a year, but when I leave
it blank I want to get all records in my report.  I can't figure it out.  I
keep getting blank reports when I leave the text ...

I have a query that shows that total sales by week by item, by store.  The
table I am using has the weekly sales for each item for each store.  The
query I am usin has a total of 12 fields(dates, Item & Store info, order
amt).  I am going to use this query to show any items that ...

I am working with a database outside of my control.  It has a particular
table with a unique number field, which is updated by code.  the "next
number available" is kept in a seperate table, and for various reasons,
I can not use this nor count on it.

Hello. I have a query that I have created that I want to use for two
purposes. The first is to run a report that details information on employees.
The second is to run a mail merge letter for each employer to go with the
reports I have just run. My logic is to just have one query ...

I'm tring to creat a fiel that have the month and the year of the data. But
turn out that is quite dificulte to do so. I excel I do that all the time to
sort out the bill I have I one month of the year, but for some reason access
can't do so. I want to have that data in the date ...

i have a crosstabe query and the data looks something like this
name                period 1          period 2        period 3
joe smith                2                    1                
john frank              3                    4                  1

I have two tables in my database. One keeps track of employees who have
special insurance enrollments. The other is a listing of all employees whose
insurance coverage has ended (that information is run off of our system, and
I import it to Access).

Hopefully this is a simple solution. I have a calculated field as follows:
Amt Due: IIf([Balance]>0 And [Total]>=[Feb 90],[Balance],0)
The [Balance] field is also a calculed field.
What I want to do is set the criteria for the Amt Due to be greater than