Search results

I gotcha, Plog! I was afraid of that..lol...thank you!

Hi Plog! Thank you so much for your help! The data is stored as "Text" since I manually typed in the words, "January", "February" and so on... I'm thinking I may have to change all of that to numbers 01, 02, etc. If I don't have to, I really don't want to...lol I realize that asking Access to...

Good Morning Everyone! Here are my questions.... 1.) I would like to be able to pull up invoices that only have months July through December. Is there a "through" expression that I can use in the criteria? The problem I'm having is that I need to use words, "January", and not dates "01/2011"...

Harsh much? My goodness... So I put the spaces back in the SQL statement and now I'm getting "Type Mismatch in Expression". SELECT [Actual Costs from Finance].AutoNumber, [Actual Costs from Finance].VendorID, Vendors.VendorID, Vendors.VendorName FROM [Actual Costs from Finance] LEFT JOIN...

Hello Goh! I havent heard from you in awhile so I hope everything is ok with you. This question is for anyone that can help me. Goh helped me out with a SQL statement awhile back and all I want to do is to change every case of "Actuals" to "Actual Costs from Finance". When I try to run the...

Excuse me while I move this question to the top of the list..lol

No takers on this one? lol No brave Access souls out there? lol

Well, I was asked to build queries and reports..that's it.

lol...No, I didn't miss it... but I don't see why I can't use it if the function is there?

What about inserting the look-up column? I tried it and I was able to look up a vendor's ID but it's not bringing up anything else that has to do with the vendor, so I need to connect it to all of it's information and bring it up somehow. (I have 12 relational tables linked together) We have no...

Hi there Speakers, Thank you for your response. We have a lot of vendors that are tied to our financial stuff. So we have a budget table, a vendors table, an actuals table, etc. He wants to be able to open a drop-down menu (in a query) and pick whichever Vendor he wants, for whatever month...

Hello all! So I have a field that gives me the difference of 2 other fields, and it looks like this in design view: Budget vs Actual: Sum(([Actual Amount]-[Budget Amount])) In the field next to this one, I need to divide the difference (which the above field shows in my query) by budget...

Good Morning, Goh! Thank you so much for taking the time to help me. I understand what you're saying and you're right. I have a slight change that I need help with. I just found out that the "Actuals" table is going to go away and the table that will be replacing it is called "YTD Actuals...

Hello! I have another thread going with another issue so I thought I'd start a new one for my new issue :o My boss asked me to build the following queries: Total Spend by Vendor Total Spend by Year Total Spend by Group Total Spend by Account Monthly Spend by Vendor Monthly spend by month...

I hope I did this right! Thanks for the awesome directions.... I'd LOVE for you to get a look at my relationships too. I tried to copy a screen shot of it and paste it here but it didn't work.

Sure...no problem! Please tell me like I'm 2 years old (lol) where to go and what to copy so that I make sure I show you what you want to see. Do you want to see the relationships between all my tables? Do you want the design view of a certain table? Oh and I'm using Access version 2002. Thanks...

P.S. I just tried something and I think I may have to settle for it... I added a new vendor ID to the Actuals table "1234567" and then I went and ran my query and although nothing else was there, "1234567" DID show up in the Actuals.VendorID column. So shall I just settle for that and just...

Hello again! I tried your new SQL statement and my query came up blank. But if I put that underscore back in, I still get the parameter msg but at least I get my vendors list...lol...I'm going to pull my hair out!

Good Morning, Goh! Here is my SQL statement: SELECT Actuals.AutoNumber, Actuals.VendorID, Vendors.VendorID, Vendors.VendorName FROM Actuals LEFT JOIN Vendors ON Actuals.Vendor_ID=Vendors.VendorID WHERE (((Vendors.VendorID) Is Null)); Please notice that in "Actuals.Vendor_ID" the underscore...

P.S. - I'm also getting a "Enter Parameter Value on Actuals.Vendor_ID" message when I run the query. I hit "ok" and it works but I know that I shouldn't be getting that, correct?