I am attempting to massage data so I can see what the maximum number
of pieces I can produce based off of various components. My query to
figure out how many of each component is available per unit is
complete and the output is:

If I have a number: 123; I would like to convert to CA000123 - must be 8
characters long; how do I get the zeros in front of the number, to have a
total of 8 char.?!
Thanks a lot,

Thank you for looking at this post
I have a table with 4 fields [Supplier], [Group], [AU], [Spend]
I would like to query this data an have a list of suppliers and the AU they
spend the most money with and how much money they spent with that AU.  I have

Can you help?   The scenario:  Click on ID # in a subform and the form opens
with the information tied to the ID, by the Item Desc.    What I want to know
is........how do you add to the criteria?  I'd like to use Item Desc AND
Customer in the "stLinkCriteria", but not sure how to ...

I have one table with data in it.
I have two queries: 1) a simple select query that filters out some records
based on values as follows:
SELECT [Wins-all].RecordNm, [Wins-all].Type, [Wins-all].[IP Address],

I wish to get an update query to run automatically (and first) when
other queries are run.
In the database are queries which are dependant on a table (Table A).
This table contains information from another table (Table B) which

I have a database that I have added records to. If I run a query that uses a
subquery (where xxx in (select top 32.....;);) that uses a top clause I get
different results before versus after compacting the database.
Before the compact the results are wrong with some rows missing. ...

Does anyone have SQL that can be used to 'flatten' a self-referencing table:
Table format:
ID
Data

One of our users reported this:
This is a sample of my database that illustrates the bug I found.
My query is searching for all records whose sum of the percentage is not
equal to 100% (1). It looks like this, very simple, but result show some

I have a question on drop table:
DROP TABLE tblPhoneCalls;
Does this work if there are established relationships?  Or do you have to
delete the relationships first?

I've tried everything I can think of, so hopefully someone may have
some advice.
I have 2 tables in Access 2003, I'll call them Table1 and Table2.
Table1 has a variety of fields, with a key field, I'll call KEY.

I know the answer to this problem must be really easy because
everything I've consulted on it has seen fit to ignore it - it's so
simple.....!
I have been trying to enter a criteria to look up records that have

The expression 'Between [first day:] and [last day:]' is not giving the
actual last day's records. But when I re-write the expression it works fine.
Please help.
Thanks.

I am doing a vacation report that would give an employee vacation to the
nearest quarter hour of vacation.
My data in the query is:
43.08

I wanted to know how to use a cross tab query that will pull the data based
on a series of  dates. I tried to add  Between [Enter Start Date] And [Enter
Ending Date] to the date field, but  I get  The  Microsoft  Jet database
engine does not recongnize '[Enter Start Date]' as a ...