I have two fields in access table. One is MinVal and other is ActVal. I have
imported this data from some escel sheet. Both the fields contain numbers.
But while importing, the access filed data types for both the fields is
'Text'. Now I want to compare these two fields and ...

I have a text field with numbers in it, in this field I wish to add two zeros
to beginnig of each record in the field.  For instance, if the old field
record was "105", I would like to update the new field to record read 00105.  
I would like to do this for all of the records in ...

I have a problem which hopefully someone can help me with or at least point
me in the right direction.
I have 2 tables of data;
Table1 has a column of data that just contains the following Text, Mth1 or

Access has a limit of 255 fields for its results tables by design.  Does
someone know how to increase that please, or how I can run a query that will
result in 392 fields.  I am involved in a major research study where we have
asked 74 questions and multiple responses are allowed ...

Is there a way to take the below query/table :
Name..........Course.........Due Date
Bob.............Math............12-MAR-06
Bob.............English.........01-JAN-07

I’m looking for the equivalent in Access of the VLookup function in Excel,
when the lookup value is between values in the value lookup column. I want to
print a report that prints the cost of various purchased products.   A query
of [quantity] * [price] for each product is simple ...

good day...
 can anyone help me with a running balance within my query...
  I have the following relevant fields:
  inoiceid

I created a query which give me the following sales result:
Customer  Product  Year   Jan Feb Mar etc
Apple        nuts       2003   10 13   18
Apple        nuts       2005   20 18   13

I have Table A with a field called Badge_Number
I have Table B with a field called Badge_Number
Table A with field Badge_Number has entries 101, 102, 103, 104, 105
Table B with field Badge_Number has entries 103, 104

I need to find out when to do somthing based on a schedule.  Here is the
problem for some of my customer schedule is Monday, Wednesday and Friday.  
Other customers Tuesday and Friday.  Yet others may be only on the 10th of
the month or 3 times a month like 5th, 15th and 25th.  ...

I have a union query that puts together two select queries I'll call A
and B.  The query runs, no errors are reported.  However, the data in
the second and third fields of query B are switched.  So now one column
that should only contain a summed total contains a ratio, and a column

I'm not sure I understand the differance, if any, between relationship in
tables and joining fields in a query. It's making difficult for me to pull
data from different records.

I have a database where I need to filter out birthdays or anniversaries to
send out cards.  They are formatted as mm/dd/yyyy.  We will be sorting the
whole month at the beginning of the month (for example, sort all April
birthdays/anniversaries on April 1), but I have not been ...

i have a table called tblBookings, i have 50 records, field ID is the primary
key
i have a field called Date. i used a query to pick up some dates which wanted
to update to this table on the Date field. how can i update to certain fields.

Hello monsters,
Probably something stupidly obvious I'm doing wrong, but anyway (platform:
Access 2003 SP1):
I have a parameter query which works great.  But when I go to use this