This one stumped our IT engineers.
I use Microsoft Access to link to ODBC areas.  I have used Access for over 5
years now and this has never happened before.  Our systems engineers think
the problem is in Access and cannot find a problem on our systems.  This

Using Access2003-SP2 with XP:
I have a form with 12 yes-no fields.
I'd like to build a report using a query to those 12 fields so that the
query qualifies any row where the OR condition is met.

hello all,
I am currently using the Nz function to populate the null values with zeros
so that I can build calculated fields in queries.  The NZ function returns a
text value, and when I try to add those values it treats them as text.  For

The date and time is stored as text, for example, as "Thursday, May 22, 2008
4:54 PM", but I need to query from it so I need it in a recognizable
date/time format.
Any advice on how to convert it?

How do I specify what table a column comes from in the Design view?  I am not
just looking up the data, I am also performing simple calculations on the
data.    Though the tables have different names, the columns have the same
headings.

I have a table that contains an employee code e his claims data in a year.
Like that:
Employee
00000001 Medical Consulting

Hi!  
  This is balakrishna i got a issue that in a table i have two fields those
datatypes are "TEXT" and "OLE Object"  how to write a query to convert text
field value to Ole object field.

I want to display a set of 2 random fields from a single address field. How
can I do this?
my fields are:
Point_ID (autonumber)

I have the following crosstab query that is populating a chart.  However, the
chart is not showing the data correctly.  The chart is a stacked column chart
showing the Def Qnty sum for each defect, which is correct.  There are four
shifts so I am currently getting four bars; one ...

Im trying to RoundUp Currency in a QUERY for a Bill of Materials.  I've
searched thru previoius posts for rounding and none seemed to work for me.
So heres the situation:
If I have a Part that is .68 [PartCost] for a package of 50 [QtyPerBox].  If

I am using MS Access 2003 and I need to make a cross table query or
query with totals to sum values between ranges.
For example I collect the following data:
Start Date   Start Date Week          End Date        End Date Week

We have different networks for different divisions, and since I can't predict
the division, I'm using a select case method.  I only entered 1 case.  The
case is the path the current user is in.  
The query runs fine.  But it's updating the current database, not the "Run

I have a select query that i would like to group by month or quarter and
compare it to the previous month or quarter. Can this be done?
SELECT VendorInv.EnterDate, Vendor.VendorID, Vendor.VendorName,
VendorInv.InvoiceID, VendorInv.InvDesc, VendorInv.InvAmt

I’ve been keeping asking questions on this discussion group for some time,
but 3 weeks ago, when I click New-Question, the web page refreshed with the
same page ,not the interface for me to enter my question. It seems only
happening to my PC, when I turned to my colleague’s PC ...

Dear Friend:
I want the highest and lowest number for every student from following chart:
StudentName Query
StID    StName    TestID    TestName    Chemistry    Bioloy    Math