Search results

Good evening Pat, Thank you for your help. PN_Identifer has strings that I want to look up like S52??-?????-??? and others. The StrRate will be a part number field in a query. So the PN_Identifer is a field in the tblRates and the StrRate will be a PN. I want to be able to dlookup for example...

Hey everyone, I am at a loss and was wondering if someone could help real quick. I am trying to make this Dlookup Function work. I have searched the forms and have yet to find an answer. Most of the answers involve the variable on the left opposed to the right side. I appreciate your help...

OK I don't really use SQL outside of Access so it's a bit different, any idea how I would translate the data above into a MySQL format? I tried it but it gave me an error when I tried the LIMIT 5 instead of TOP 5. Let's start simple. How would I get SQL to pull the TOP 5? It's giving me an...

Oh very interesting, I have never tried tried to called a SQL procedure before. The first step I need to do is determine how to create an outside SQL procedure. How would I do this? I believe maybe IT would have to help create the procedure as these tables pull from SAP, is this logic correct...

Thank you for the response and help so far Pbaldy. I am new to VBA procedures and coding. Do you have an example of the code? I am guessing you would code the module as a function?

Following up on this. Does this work well with a SQL table?

Thank you for this site, it's getting me to the next steps. I put together some of my own code based on his model. I am pulling data from an SQL warehouse, there's many records. As you can see below I have limited the data pulled by the following: 1. Plant 2. Date I am trying to pull these...

Hey all, I am trying to create a query that would pull the top three recent dates for a part along with any extra data I need to add. I know how to pull the Last and First but I am confused how I would pull the top three by most recent date. Next, I would like to count them by the part it...

Hello everyone, I'm trying to avoid the TITUS Version 3.5 pop up box, Yes or No because I know the automated message does not contain non confidential data. Anyone know how to code in Access/Outlook to send a email message while automating this Yes and No Dialog? You'll probably mention I...

From the look of that code it doesn't look like it would pull the last 5 line items. I only want to pull up to five items and do an average.

Edited 6 to 5.5

Hey everyone, I am trying to figure out a way to filter the average price of of a Product within the last 5 occurences (Line Items). It would pull a week back so WHERE: Between Now()-7 and Now(). Example: PARTID | Price | Date --------------+-------------+---------...

Hey thanks for the help! Got it!

Can you provide a sample of the data and what you want it to look like. There's not enough here to answer your question.

Good afternoon everyone, I am trying to write an if statement that will only capture a string if the string is in the following format: '76___-_____-___'" / 'S92___-_____-___'". IIf([PART#] = '76___-_____-___'", "Yes", "No" Is there a function I can use to get the results I want? I...

I was thinking about this the wrong way. I appreciate your help! I did as you said and filtered using the Query.

Append data in an Access Pivot Table to a Table (or requery on it) in Access Hey everyone, Is there a way to append a pivot table to a table or possibly make a query based on a pivot table? I need to get a count of Part Numbers and I need the average price for all these parts. Additionally I...

Awesome. Thanks so much, I really appreciate the help and example! Happy holidays! I will give this a shot.

All good suggestions. Thank you! Can someone give me an example of a recordset (Skipping blank columns) and I can take it from there? Thanks for everyones help! Oh and Minty, thank you also but I'm gonna try and avoid pivots. Maybe a cross-tab would work. I'll try and give that a shot also...

I am pretty decent in VBA but I don't know everything yet. So their's no way to hide a column that is null? Hmmm, That's too bad. Would of made things a lot easier. Yes this is strickly Query! (I mentioned report because I use the query as a report to the user) :) Alright so let me get a...