Recent content by rjonas

Thank you for your responses. I apologize that I wasn't clear in what I was looking for... I am aware of the IsNull function and use it frequently. In this case, I want the records where the Forecast Owner is Null (or empty) but I also want any existing records that have the same Client...

I keep thinking there must be an easy answer to this question but I've yet to figure it out... I have a couple different reference files that get updated each week. Sometimes there are missing data elements, so I'd like to structure a select query to show me those records that have blank...

RG - indeed it did... you're the best! Thanks!!

Thanks RG... I will try this... Now I need to figure out the syntax to do this in a query (i'm not very good at VBA coding...) :-)

I thought I had this figured out but I'm stumped... :) I have a customer number list that looks like this: 1234_Cust 12345_Cust I want to strip off the "_Cust" part and be left with: 1234 12345 I thought I could use something like this...

Thanks for the replies.... @pbaldy: I think I didn't mention that there wouldn't be an exact match between the vendor listing query and the field in the table (the description field will like have other wording, like "cost accrual for ABC Vendor") to which I'm trying to extract records, which...

This seems like an easy thing to do but thus far my query has returned no results even though I know what I WANT it to do should have results.... I have a summary select query that essentially is a listing of vendors. I want to use this query in another query that will pull certain records...

Got it.... Using Beetle's suggestion and changing the parameter "1" to "4", the query ran and gave me the results I wanted. Thanks!!

Nope, you understood correctly... I tried this previously but got an "Invalid Procedure Call" error, so figured I'd done something wrong.... Any idea why I'd get an invalid procedure call? I added "is not null" in the criteria field as I know you can get this error on a null field/value...

Hi all - I'm trying to construct a search query on a particular field that has text contained within a specific format... The text will be a combination of numbers and letters (hence the problem) but the format will always be the same... I'm using the following formula, which works great when...

jdraw - It's not that I have to change the table names, it's just that I don't always have the end sight to know exactly what I want my tables to be named or how I want them grouped until after i'm already designing queries, etc. A lot of my tables are reference tables or source information...

John - Thanks.. I'll check it out! Appreciate it.

I have a feeling this either can't be done or it's so simple that I can't readily see the solution... From time to time, I have a need to rename table(s) in my databases. This causes some issues with queries where these tables are used, since the query no longer sees the original table once it...

I have a database that I have split into a backend (tables) and frontend (all the other stuff). The backend DB resides on a network fileshare/server and the performance of editing queries and opening tables is less than desirable... I found this procedure online that says by keeping the...

Thanks for the input! Will give it a try when I get home and will advise how it goes and if I have any other questions. I've always been afraid of VBA and figure it's time to get over it. :-)