I am trying to create a field in my report which will show the number
of days between the LossDate and Today's Date if the issue has a
status of "Open" and if the status is not open (i.e. Closed) I want
to see the number of days between the LossDate and the CMDate

I'm stuck on this one.  I have two tables - tblContacts and tblHistory.  
There is a one to many relationship (1 contact to many history records)
linked on ContactID.
In the tblContacts there is an AccountMgr field that is the same info as a

Hello, I am creating a text expression in a query where I am concatenating
fixed text phrases with a data field (eg.  "See the picture at
http://picasa.com/rwilliamsfiles/" & [ID]).
Currently, I can not click to link to the desired URL. How do I embed hyper

Good morning all,
I have a query that have records of route and stop information, I need to
put a sequence number starting from 1 to n (n is the next record, until the
end) restarting at the new route number.  

How do you allow a query to accept data to input. Pretty sure this works
sometimes and not others. So if I have a form that looks to a query for
information and I want it to update the table...well can I do that. Thinking
it might have to be a single table query? Thanks!!!!

HI.. i need help on solving one big problem i can't get the solution..
I have a query that gets some values and also a month text from one table..
based on a form parameters.. What i want to do is to add/create a column on
the query and make that column depend on the text of ...

How is it possible to merge 2 different tables together.
Table1 has AddressID, ApptNum, ApptDate, CompletedDate
Table2 has AddressID, NANum, NADate, CompletedDate
I want to merge into

I have created a query of personnel info which I am exporting to Excell via
a macro with OutputTo.
For printouts In Excell we are going to need page breaks per departments. Is
it possible to do a ForceNewPage in a query in Access. I have gone thru many

It seems like I am posting daily these days.  I have only been using MS
Access since Novemberish and I appreciate all of the assistance I get when I
post.
Today's issue is just a simple query trying to count only those fiels in my

In a  query I have gone to properties and changed unique records to yes but
I am still getting unique records the query is one field only
Any ideas
Thanks

I have 2 queries that I'm desparately in need of help with...
1) I have a date field, where the date has been captured in either
yyyy/mm/dd format, or dd/mm/yyyy format. I need to change all of the dates
that are in dd/mm/yyyy format to the yyyy/mm/dd format. HOW on earth is this

Yesterday I built a query, which had the source of two other queries.  Built
a report and everything looked fine.
Today, I went into the report and noticed that the grand total of 'errors'
was the total errors multiplied by three.  The total volume was not the total

I am not a guru with access and this problem has me puzzled...
I have a table wiht multiple months of data.  The key fields are a cost
code, report date and then several values (Budget, Actual, Forecast, etc.)  
All data is in the same table.  I would like to create one query that ...

Hello, I am attempting to make an If-Then type expression that will give me
multiple "Else" values.  (doesnt have to be If-Then, any variation that will
work is fine)
For instance, I know this isn't correct language but I essentially need

I have reports that list the All Invoices for the "Current Month" & another
for "Last Month". With the "Last Month" Query I have the date parameter
recorded in the criteria of the Query (eg Between #01/02/06# and #28/02/06#)
but I have to update this at the start of every month. ...