I am working with the following fields in my query:
1. Total
2. Discount
3. TotalDisc

I need to remove lead zeros from all records of a table

When I enter 25% in my query it displays as 2500%, what can I do to have it
display as 25%?
My field size is: Single
Format: Percent

Good morning,
I am trying to make a query to build a graph that will be a sub report. It
runs from a Print Dialogue Box.  I have a table called tblCalls which has the
Date the call came in and the Call Category i.e. Appt Booked.  I was trying

Can anyone advise the code to use an Access query to convert a date or time
to a string - e.g. 04/07/2005 to 04072005?
Thanks

I am trying to build a query that will sum all my cash receipts for each day
of the month.
I built a query to pull the data and the amount from the table.  I've
grouped the query by date, but now I can't figure out how to create a query

 I'm not very good with SQL and was wondering if someone can help me a bit.
I need a few queries to select from the tblInventory and do the following:
one query to give me the sum of the fields invAdjusted, invRegUsage, and
invWaste but for a date range.  The date field is in ...

I have three tables: tbl_cust with customer data (client_ID, number, name,
adress, ...), tbl_priceincrease with increase_ID, date of price increase,
increase percentage and tbl_incrapplic with client_id, increase_id and
application (yes/no).

My table:
REP text: 4 characters
One text: 10 characters
Two text: 10 characters

I have created a form which is identical to a survey being given to new
graduate nursing students.  25 questions involve clicking on one of four
option buttons within an option group. The four options are strongly
disagree, disagree, agree, and strongly agree.  The option group ...

Using A2K.  I've got a subform that displays a list of agencies by date for
each client.  For example, currently there are 10 agencies.  Client #59 has
30 agency records:  one set for 6/22/2005, one set for 7/1/2005, and one set
for 7/15/2005.  If the user adds an agency for #59 on ...

I have a form that contains a list of dates, and I only want to show the
dates that are from the current year.

I want a query with fields that will either perform a caluclation dependant
upon the value of a "code" in an underlying table, or return zero if the
record does not contain the specified "code"

My Access-97 table looks like this:
Field 1
A
A

I wish show a calculated field in a query.
I have a data field, and i wish show the number of week.
After read the help online i understand i will write
Week : Format([DataField];"ww";vbMonday)