Search results

of anime fans

Octopi in the

If you need to have the results from BOTH sides, then a UNION Query is a possible solution. An overview of a possible solution is below, but you should also look Up UNION Queries for additional details. The First part of the UNION Query would be the same as the Query that you have now (All...

of King Poseidon

I would be interested to see the structure of this Table. If you are storing similar information in multiple columns of the same Table, then there is a possibility that the Database is not properly Normalized. If that is the case, and the Database is adjusted to resolve the Normalization issue...

Thank you Col for confirming that there is no difference

You can always come back here to ask the lot of us. There is nearly always someone around that will be willing to respond to your Questions. :)

Jamie, Thank you for posting back and describing what worked for you. There are always others with the same or similar questions that can benefit from the information provided by your success. -- Rookie

You should be able to use the IIf() Function to do what you want. The format is: IIf({Condition to test}, {Value to display if TRUE}, {Value to display if FALSE}) Give it a try and get back if you have any further questions -- Rookie Note: It looks like jdraw and I replied at the same...

What's the difference between a "Chinky" and a Take Out Asian Restaurant?

Are you trying to build a dynamic Query based on user input? In that case, the QBE Solution suggested by Pat Hartman (with Parameters) would be an good option. You can also make the QBE version, and use the SQL Code as a basis for the VBA Code that you are trying to create. -- Rookie

Simply stated, usng the DoCmd.TransferSpreadsheet method will create a Spreadsheet that resembles the Access Datasheet created when you run the Query. I am not sure what you need to do, but there are other methods available if this is not the Format that you are looking for. More details would...

I have to agree with Pat that the effort is as straightforward as she is suggesting. I have had similar success in MS Access to SQL Server conversions. The one wildcard is in the interpretation of what "a truly huge application" consists of. It has been myt experience that one programmers...

saved the oceans

Have you checked the Types and Values in the Field [dateTime]? The DateValue will Return what you expect if the Type is String or the Type is some form of Date, but if the Value is Null, it might not return what you expect. If a Null value is the issue, then consider using Nz() and defining a...

You should double-check the data types of your Fields, since "data type mismatch in criteria expression" most often means that there is an instance of differing datatypes in a comparison or a Concatenation. From what I see, an obvious choice to consider would be whether tClients].[ClientRef] is...

Pat, Thanks for the reply. I have the standard setup for a Split Database. Each user has their own copy of the Front End on their desktop the Back End is located on the Server as close to the root as IP Security will allow. I also have Bob Larson's FE Update Tool installed. I will look at...

the game of

Sorry, I forgot to say that I already moved it

The second , "" was in the wrong position.