Search results

Is there a way to supress one field if the value is similar to another field? Example Field / Value Customer / Ocohee Park Account Name / The Ocohee Park In this case, I would want to show the value in the Customer field and hide the value in the Account name. Example 2 Field /...

Yes - use an update query. Update the Item field with >> [Code]&[ID] (type it just like that)

Thanks for the response, however, I don't follow. I'm pretty sure my situation is completely different. I am using access as a front end to an Oracle database, so I have no control over table structure. I have to find a way to do this within a single query (for multiple reasons) if it is...

I don't know if this can be done... I sure hope it can! I have 6 date fields(D1, D2, D3, D4, D5, D6). I want to determine the most recent date in the fields and populate a new field (Drecent). A couple of wrenches to throw in... Any date field can have a null value. Multiple date fields...

I don't post much... and here is why. I thought I'd share for anyone new coming out here. I use the search feature before I do anything else - and was racking my brain with a nested iif function, trying to figure out how I could possibly be messing it up. This "old" post lit a lamp in my...

How many tables do you have in your query? How do you have them joined? (what fields are you joining on?)

The Format(Bday,"mmdd") should be in the field line and the Between....AND.... in the criteria. It appears that you have put the whole thing in the criteria line. If I misunderstood, sorry! hth CM

Thanks to both of you for the suggestions. The Allow Zero Length "Yes" was the best solution for what I was doing. Thanks so much for the response!

I'm sure there is a better way to do this... You could create multiple queries based on the different Hubs. Name the query what you want the tab on the spreadsheet to be called. Then - create your macro with a transfer for each query with the same file name for each query. Each query will...

Is there a way to define the Field Size and Data Type in the query when performing a Make Table? I've tried Setting the field size and data type in an "existing" table and then use an append query to fill it, however, I receive a validation rule error. I can make the table and then change...

If you have other fields on the horizontal that you want to push or pull based on the size of the field, the best way I know to do this is to combine the fields. =[Field1] & " " & [Field2] & " " & [Field3] Then you make the box as long as you want and the data will always have the appropriate...

I know you have to reference the subreport from the main report in order to get a page break (with code to determine when the break occurs) in the subreport to work properly. The Main report doesn't recognize the VBA in the subreport... What is the code to do this and where do you put the code...

Check the query to make sure you only have the fields you are showing in the query grid If you only want to show: Question # Yes Count No Count BUT you have brought down the Responder Field and unchecked the Show box - then you will still be grouping on the Responder - and each Responder...

I'm not sure if this will work - but I think I had the same problem and made a change in the QUERY properties... open the Q properties and Make "Unique Records" = Yes Good Luck!

That is awesome Jack C - thanks for your help! That is just what I needed.

You COULD create another table with the Zip Codes as one field and the Sort Order as another field (1, 2, 3) then attach the table to your Query and use the Sort Order field to sort on. I'm sure there are other ways - but this may be the simplest - especially with a large number of Zip Codes...

Do you know if there is a way to count the number of times a certain letter/number shows up in a single field? For example: Field Value: 123ABC234ABC345ABC456DEF If I want to count the number of times a "3" is in the field - can I do this? So - I could update another field to Y/N based...