Search results

The main difference between UNION and UNION ALL is that UNION purges duplicate items from the resulting dataaset. Perhaps the need to purge was somehow related to your problem. Good to see you are up and running. -- Rookie

I am not positive, but I believe that the (+) notation indicates an optional Field in a comparison with the side that has the (+) being the optional one. The closest thing I can think of that might accomplish this would be an Left or Right Join. Try experimenting with Left and Right Joins and...

Another thing to consider is whether you want or need to meet with the Developer as opposed to having the project done offsite with contact via Skype Go-To-Meeting, or similar means. In that case, your location (region at least) woule be helpful

It looks like you are checking the Flag [Forms].[SalesForm].[DetailOption] to see if it is Yes/No or True/False. You could use something like [Forms].[SalesForm].[DetailOption]=True instead. If that is not the case and you are checking to see if a Field [Forms].[SalesForm].[DetailOption]...

As vbaInet suggested, you could add a new field called UserPreference that is based on the result of an IIf() that checks the Record's Selected area and returns a value of 1 if the AreaID matches the User Selected one, or 0 for any other value. If you then sort by all required Fields (perhaps...

If your Listbox it based on just the Table, it may not be able to see the Text that is displayed inthe Combo Box, and should not be used as the Source for the Form. If that is the case, then you can create a Query that JOINs the Table in Question with the Table containing the Text that you want...

Would it be possible for you to display the SQL Code here? Perhaps seeing the code will allow for different observations or suggestions

then go to

took the time

about to expire

Airlines tickets on

on the top

begin preparing for

Arctic tundra and

was not shining

the third Saturday

the Queen a

sneezed three times

causing lots of

a new animated