Search results

I'm not 100% sure how to post a DB & I'm not sure if I'm working with confidential information.. but I used a calculator on some of the numbers and some work while others are way off. I wonder if it's just bad data?

I tried doing this, I left the other two options "Group By" and "Summed" the dollar value.. when I run the query, I get a dollar amount that's like $723095729067 and doesn't make sense with my original numbers?

Hey all, I have a query that contains three headings: Supplier, Number, Dollars or John/ 1123/ $123.45 John/ 1123/ $69.05 John/ 1124/ $3249.34 How do I get the duplicate records (John, 1123) to SUM UP the dollar amounts and turn that into one line? So it would just be John/ 1123/...

Is there a way to modify Access (maybe in options or some kind of code) to make it look ... unlike Access? I have a switchboard that pops up when I open Access, and it's ALL I want to be displayed; no navigation bars, no tool bars, none of the typical Access things. Is this possible?

I imported the excel file into a blank table; do I keep all of the data in the file or just the heading/field names?? I don't really understand the next few steps. Could you help?

Maybe there's something easier I can use instead of VB??

Hey All, I have a switchboard (form) in a database with several buttons. One of those buttons is "Exit." Upon clicking that button, I want a MsgBox to pop up saying something along the lines of "Are you sure you wish to exit?" with the options Yes/No, and then when Yes is pressed, a "Do you...

Hey everyone, I'm working with an excel file that I have to import into an access database twice a week. I have to run a special macro on this excel file before I import it. Once I import it into acess, I want it to replace the past information it has in the table and put the new information...

You just made my entire day :) Now, even though I have duplicate values in the PO Number but different values in the Supplier Name, no values will be lost by selecting 'group by'? THANK YOU!

The form is pulling information from a query I have based off of a table. I figured the simplest way would be to filter the query somehow so on the form it would show the appropriate headings. My Row Source on the form (for each individual drop down) already contains its own bit of...

The videos were not helpful with what I needed to accomplish :( I did learn something from them though! To give everyone a better idea... I have this: And don't want duplicates appearing.. but also don't want to lose any information.

Hey All, I'm having a LOT of trouble with this. I have a query that contains PO Number, Supplier, Last Name, First Name and Value. I wanted to create a form that contained unbound drop down menus so I could run reports on individual components of my query (ie: if I wanted to see all of the...

Does anyone know where I go from here?

I got the "Group By"'s to appear. Now what? Do I group "PO Item" by 'Sum'? Do I put anything in the criteria for PO Number?

I understand what you're saying but have NO idea how to actually do it. I'm working with Access 2007 if that helps?

Hey Everyone, I'm new here and am in desperate need for some Access help! I have two tables that are put together into one query with title headings, "Mission" "Master" "PO Number" "PO Item" "Item/Acct Value" and "Supplier Name". My goal is to create two reports from this query (one of sales...