Search results for query: *

Hi, I have three tables that have records that in exist in all three tables, some in both, some in just one, etc. I would like to use full outer join so that all records will appear on the report no matter what table they are in but the option is always greyed out. Thanks in advance for any help.

I have an access database with two fields that contain activated date and terminated date. In my report, I have a parameter for activation date and the formula is set so if that date is in the activated field or the terminated field it should show on the report. Whats happening is that if a...

I have created a report in 2008 and when I open it in the viewer, it does not give the option to refresh or prompt for the parameter. Am i missing something? Thanks alot.

I tried this and I get- Syntax error (missing operator) in query expression 'tblStore3.Store3ItemNumber = items.item left join tblStore2 on tblStore2.Store2Itemnumber = items.item left join tblStore1 on tblStore1.Store1ItemNumber = items.ite'.

The tables are: tblStore1 Store1ItemNumber Store1ItemDesc Store1Dept Store1Category Store1Price tblStore2 Store2ItemNumber Store2ItemDesc Store2Dept Store2Category Store2Price tblStore3 Store3ItemNumber Store3ItemDesc Store3Dept Store3Category Store3Price The report needs to include all the...

I have three tables that contain item data from three stores. The tables have some items that are in all three stores, some in two of the stores and some that are just in one store. I want to create a report to show all three stores combined so the prices can be compared between each store. I...

We have a Merlin Legend system and I am wondering if it possible to somehow transfer calls to a park line so you could then get on a walkie talkie and announce that someone has a phone call on line whatever. It would even be fine if I had to go around to each phone in the building and program...

Thanks alot for the help and quick response, everything worked great.

Ok so I got the operator set up and all the lines appear just fine. The only problem I have is that the last three buttons that I would like to program features onto will not let me. When I go into central programming and try and change them it says programming error. They are assigned to lines...

We have a legend phone system that currently has 3 operators set up, extensions 110, 112, and 140. I am wondering how I can set up another extension as an operator so they can have line appearances as opposed to just a pool button. From what I have read, I understand that operators can only be...