I am trying to edit a word viewer document to vista but it wouldnt let me
alter it how do i do this

This is the IIF statement I'm using, but it's coming up with the old
"Does not include expression as part of an aggregate function error."
I want the birth date to appear in the Pink Birth Date if it's between
those dates and otherwise leave it blank.

I think I have a simple question.  I have a database where up to three
checkboxes can be selected.  I would like to create a query, or report, that
will show if any two of the three are selected.  I'm a novice at this, so
please feel free to elaborate as much as you can!  I keep ...

I have a table containing a list of businesses and some general info.  One
of the fields in my table is TotalAssets.  What I want to do is create a
query that selects the 10 rows above and below a TargetAsset parameter that
is input by the user.

I have a following table structure:
Task (Text), 1(first day, integer), 2(second day,
integer) ...etc. 31 (31.day, integer), StartTime (Data/Time),
Monat(integer),

I have a table that has two fields, State and Acres.  I am trying to build a
cross tab query with State down the left side and buckets of acre ranges
along the top.  It should look something like:
       1-99    100-249        250-499

I'm trying to get a sum of two columns in two different tables.  My problem
is that if the Salesperson Code isn't in both tables, it will not do the sum
expression.  For example:
Invoices Over 60 Days                            Invoices to Reserve

I had to pull data from another system and place into access. one of the
fields is a memo field that contains a file number. The format of the file
number is ##-###.
Is there a way to find the text using wildcards *#-##* in a query and only

I am trying to create a report on access from Table.
However, I would be using more that one table for creating the report. I
will have a one main table. And then I will have many sub-tables. Each
subtable is different for each ID of the main table. Is there a way to link

I've got an access database I'm connecting to using ASP.NET. Several columns
in the various tables of this DB are in a time format of seconds since
12:00:00 1/1/1970. Is there a way to run a query using SQL that I will be
able to make sense of. For instance:

I would like a query function that will extract out only the text between
<Note> and </Note> in a variable lengthed text field. Sometimes the
parameters won't exist, and in that case, I would want to leave the text only
that exists in that field.

I have a table with the following:
Column X | Column Y
2|Type1
2|Type1

Hello all you MVP's and Access enthusiasts!
I have a tricky one that I can't resolve and thought maybe someone
could help!
If [Ti] is "0" then [Hi] + [AdditionalUnits]

When I tried to delete a record, I get this message: "Records not deleted.
Data read only"

I am trying to get a Median calculation per group of numbers in a query.  I
am a novice at VBA as you will tell from my scripting below but i just get
the feeling its something simple I'm overlooking.  Thanks for all your help
in advance!