Can't add columns to report's SQL statement

[June7 via AccessMonster.com]

I have the image. See what you mean by grayed out. Odd some are, some aren't.
Very difficult to debug something when you can't replicate the problem, which
is the case here because the boxes show fine for me. Things to try: Opening
on other machines; create a new project, import the tables and this query
into it; create new project, create tables and query from scratch; reinstall
Access.

This 'grayed out' effect is like what you would see in Excel when you have
multiple cells selected with different property settings, such as Wrap, and
then you view the properties window and the Wrap check box is gray,
indicating the property setting is not the same for all the selected cells.
However, at a loss as to why this would happen in an Access query. Will look
at it again when I get home, but as I said, not seeing the problem. At this
point suggest you might want to start a new thread with an appropriate title
to get new perspectives.

http://www.box.net/shared/tj0ydelb5y

I need the link to the image file. It doesn't appear to be in my Box.net
ShareAnyOne.

[quoted text clipped - 20 lines]

 

[Laurel]

Thanks for the suggestions about things to try. Will do.

I have the image. See what you mean by grayed out. Odd some are, some
aren't.
Very difficult to debug something when you can't replicate the problem,
which
is the case here because the boxes show fine for me. Things to try:
Opening
on other machines; create a new project, import the tables and this query
into it; create new project, create tables and query from scratch;
reinstall
Access.

This 'grayed out' effect is like what you would see in Excel when you have
multiple cells selected with different property settings, such as Wrap,
and
then you view the properties window and the Wrap check box is gray,
indicating the property setting is not the same for all the selected
cells.
However, at a loss as to why this would happen in an Access query. Will
look
at it again when I get home, but as I said, not seeing the problem. At
this
point suggest you might want to start a new thread with an appropriate
title
to get new perspectives.

http://www.box.net/shared/tj0ydelb5y

I need the link to the image file. It doesn't appear to be in my Box.net
ShareAnyOne.

[quoted text clipped - 20 lines]

TIA
LAS

 

[Laurel]

Where do I look to find the patch level of my Access?

I have the image. See what you mean by grayed out. Odd some are, some
aren't.
Very difficult to debug something when you can't replicate the problem,
which
is the case here because the boxes show fine for me. Things to try:
Opening
on other machines; create a new project, import the tables and this query
into it; create new project, create tables and query from scratch;
reinstall
Access.

This 'grayed out' effect is like what you would see in Excel when you have
multiple cells selected with different property settings, such as Wrap,
and
then you view the properties window and the Wrap check box is gray,
indicating the property setting is not the same for all the selected
cells.
However, at a loss as to why this would happen in an Access query. Will
look
at it again when I get home, but as I said, not seeing the problem. At
this
point suggest you might want to start a new thread with an appropriate
title
to get new perspectives.

http://www.box.net/shared/tj0ydelb5y

I need the link to the image file. It doesn't appear to be in my Box.net
ShareAnyOne.

[quoted text clipped - 20 lines]

TIA
LAS

 

[June7 via AccessMonster.com]

1. click the Microsoft Office Button
2. click Access Options.
2. click Resources
Just below the 'about Microsoft Office Access 2007' you should see fine print,
something like:
Microsoft Office Access 2007 (12.0.6423.1000) SP2 MSO (12.0.6425.1000)
3. click About button, will see the same statement at top of frame.
I think SP2 MSO indicates 'Service Pack 2 Microsoft Office'.

Where do I look to find the patch level of my Access?

I have the image. See what you mean by grayed out. Odd some are, some
aren't.

[quoted text clipped - 28 lines]