I have 8 pieces of data taken on three days.  6 of those pieces were taken
one day and the chart keeps summing them so that bar is 6 times the value it
should be.  Anyone know what to do??

Recently when going to print a report in Access, It will print double copies
automatically.Each time I click print  I get the error " the value you
entered isnt calid for this field" . then it will print, then when I click ok
it will give me the same message.

In that order - years, months, day
=DateDiff("mmddyyyy",[BirthDate],Now())+(Format([BirthDate],"mmddyyyy")>Format(Now(),"mmddyyyy"))
I got the above from a post but when I try it I get #Error
Help

I have three tables whose data flow into a query:  
Table 1 - recipient info (recipients are autonumbered - primary key)
Table 2 - personal services agreements (each psa is listed once, but there
may be  multiple p.s.a.s for each recipient - which is in a lookup field from

if I have a table of  transactions on a bank account with two fileds:
Field_1 holds the date of the transaction
Field_2 holds the amount  of the transaction
What would be the quiry which would add the third filed Field_3 containing

With the runtime for 2007, does that mean it be deployed on a MAC?
QB

I was entering descriptions into the properties of reports and I must have
accidentally checked the "hidden" box in "attributes." The report is still in
the database, it just does not show up on the list in the report objects. How
can I unhide it?

I am opening with a command button a Form in a databese like:
Private Sub Abrir_balanzas_Click()
On Error GoTo Err_Abrir_balanzas_Click
   Dim stDocName As String

In a query, in the criteria I write the following IIF statement:
IIf([Forms]![frm_search]![date_1] Is Null,
[tbl_projects].[date],
[tbl_ projects].[date] Between [Forms]![frm_search]![date_1] And

What I am trying to do is to click a button and have the insert hyperlink
dialog box to display.  I then select the doc to insert as a hyperlink and it
is saved in a field called AttachLink on a form called f020Attachments.
This works great using the below code...

AIUTO.......

Hi, i want to make an query based on a multiselctboxin a form. i have the
following code:
   Dim db As DAO.Database
   Dim qdf As DAO.QueryDef

I had already imported my data into a table and created a form.  I realized
that I didn't require a certain field to be required until after the form was
completed.  Can I go back and change that?  It works when I add a new record,
but I need it to be required for all records.

I accidentally overwrote my "Blends" autoformat. Short of reinstalling, is
there any way to restore this particular autoformat?

I am using Excel 203
I created various forms in Excel.  Now I want to put these forms on our
Intranet so that everyone will have access to them and be able to fill them
out in the computer.  I made the forms templates, but when I bring up an