Search results

thanks so much you two... i think I see where I was making my mistakes now. you've been a huge help!

Okay, so I have a table, created from an action query which shows all orders for a specific RepID. One of the fields in this table is ProductName. There are many many prouct names in this table, and potentially many more as more product is added. Many of the names of the products are very...

thank you so much for replying... and you'll have to forgive my ignorance, but I don't want to do this wrong. I know just a wee tad of VBA and even less of SQL. Where do I code this sexactly, and how? Your help is IMMENSELY appreciated. :)

I'm told (via the non-helpful help system packaged with MsAccess) that the way to 'turn off' the helpful confirmation message related to an action query is under tools>Options>Edit/Find tab, and then uncheck the appropriate boxes. I've done this. In fact, right now I have all three boxes...

hi folks... I wonder if I could get a little more help with my database, since you all have been so helpful in the past. I'm on the home stretch here, but one of the simple things is stumping me. I have a form named [Payroll] which is supposed to calculate total commissions for our employees...

You're a lifesaver. Thank you!

Alright. At least I know now why it's not working. The 4 vs. 'Digital' issue I had already thought of, and neither option makes any immediate difference, so I think that the main problem is that it's pulling from a parameter query. I've made an attempt or two at having the query pull from a...

Ok that makes sense. can you point me in the right direction to rename my controls then? How do I get that done?

Try # 2...this should work this time.

Trying to send you my database, but the upload keeps failing. hm. lovely.

I'd be happy to, let me see if I can get this to work... in the meantime, I wonder if you can answer this for me. It may solve the whole issue. Is it simply because I'm asking the function to pull information from a Query, and not a Table? It seems to work fine when I change the values to...

Ohhhhh ok I think I see what you were referring to in terms of syntax. Sorry about this... After reviewing that link again, I came up with this: =DCount("ProductSold","Payroll1","ProductSold='Digital'") Which looks like it fits the syntax of the link you sent me, but I still get that #Error...

Or this maybe? =DCount('ProductSold','Payroll1','ProductSold'='Digital')

Ok please don't get angry... I'm not trying to be rude here. So the function should look like this:? =DCount('ProductSold','Payroll1','ProductSold = Digital')

Ok... I think I'm getting closer. This is the function now: =DCount("ProductSold","Queries!Payroll1","ProductSold = Digital") Now, instead of any errors, i'm getting a blank field. Any suggestions at this point?

How do I build a form which will pull only certain work orders from my table [Work Orders], filter it through a query, [Payroll] which gives me only those work orders which match a certain repID#, for only certain Invoice Dates, and and then display a talley of the total number of times a...

Sir, your link is for DLookup, and at the risk of sounding completely ignorant, what is wrong with the syntax I'm using?

Ok... I tried a new Tactic while I was waiting for a response. Here's what I have so far... I've inserted a subform on form [Payroll], called at the moment [Payroll1], which pulls the neccessary work orders, filtered by install date, rep id and status code. then I created a text box, and...

Ok, I admit that I know just enough about Access to be dangerous, so maybe I'm going about this the wrong way... I'm trying to set up what seemed like a relatively simple Query, but for whatever reason it's just not behaving in the way I thought it would. We're attempting to set up a database...