Search results

Ant, What you wrote works, but isn't it a little confusing to give two separate table instances in your query the same alias ("C1")? (Even though they are both referring to the same table.) I don't know much about SQL naming conventions. Is this standard? Duluter

I'm having trouble reading your query results. Could you reformat with some kind of identifier between each field? For example: Field1 # Field2 # Field3 100 # 423 # 543 345 # 311 # 212 983 # 974 # 121 Also, could we see your SQL? Duluter

OK. If you get stuck, try the following: Assume that you have a table or a query that has a complete listing of all the dates you are interested in reporting on. Depending on how your system is currently set up, you could generate this by querying for the distinct date values in one of your...

Yes, I see the problem. What you could do is bring all these members into qry1 somehow, like this: DateNum # MemberID # Count of MemberID 01/01/2008 # Member1 # 2 01/01/2008 # Member2 # 1 01/01/2008 # Member3 # 0 01/01/2008 # Member4 # 0 01/02/2008 # Member1 # 1 01/02/2008...

Glad it worked!

So, from your base form (switchboard), you might have a button that says, essentially, Choose a Report, then that opens up a form that has the parameter pulldowns/textboxes and a series of buttons, and each button corresponds to a particular report they can run? Isn't it ever a challenge to...

Bob, I think you may have convinced me. :) Duluter

The report's open event fires before the report runs the query that the report is based on, right? If so, then there wouldn't be any requerying. It's kind of hilarious to me that we're having this discussion right now because I am working on a database in which I had originally gone the...

1. Right. My first paragraph was meant to be conceptually separate from my second paragraph. The form in question is the parameter form. The switchboard/database window issue is separate and I think we're all in agreement on that. 2. I brought it up because bob and dennisk both suggested that...

OK. I'll take a stab at this, but I'm no SQL master. I'm sure others will jump in and flesh this out. Let's call the query you already have working qry1. I think you need to do a self join on qry1. Something like this: SELECT a.DateNum, a.MemberID, SUM(b.SumOfCount) FROM qry1 as a, qry1 as b...

Totally agreed regarding the database window. I was envisioning that the report would be opened from a switchboard or such. Conceptually, it makes more sense to me to open the form from the report rather than opening the report from the form because the report needs the form. In other words...

I was wondering the same thing that Gemma was @ #31 above. Others here state that it is better to open a form, set parameters, and then open the report from the form. I don't have much experience, but I would think that, in many cases, the opposite approach would be better. For instance, if I...

I'm not sure what you mean by this. Could you clarify? Also, I'm not sure I understand your example: DateNum # MemberID # Sum of Count of MemberID(previous 3 months) 01/01/2008 # Member1 # 0 01/01/2008 # Member2 # 0 01/02/2008 # Member1 # 2 01/02/2008 # Member3...

I think the main problem is in your WHERE clause. It should be asking about the BudgetID field in the tblBudgetTime table, not the tblPXTime table. Also, in the SELECT clause, bring in tblBudgetTim.BudgetID, not tblPXtime.BudgetID. If you bring in tblPXtime.BudgetID, the IDs on some rows will be...

I used this and it seemed to work: SELECT tblBudgetTime.BudgetID, tblBudgetTime.[Year/Month], IIF(isnull(tblBudgetTime.COs),tblBudgetTime.BudgetTime,tblBudgetTime.BudgetTime + tblBudgetTime.COs) as TotBudget, tblPXTime.TimePX FROM tblBudgetTime LEFT JOIN tblPXTime ON (tblBudgetTime.[Year/Month]...

Good advice, HiTech. Thanks! Duluter

I have thought about this issue a lot lately. On the one hand, you have added value to your company by reducing inefficient work practices. On the other hand, from the company's perspective, they'll be paying you ~$50,000 per year for this work. Have the tools you developed saved the company...

Hi, everyone. I wonder if people could share their experiences with ensuring quality control in data entry. Specifically, I have a database that office staff enter work order data into. I want to make sure that all of the work orders have been entered correctly. They are usually entering them...

Great feedback everyone. Thank you. Yes, I suspected that the poster on the other forum was not entirely sure about what they were advising re "safer", but I wanted to get your input. I'm feeling the love on the bound form issue. I developed a database for a family member's business. The data...

Cool. Thanks, Pat. Duluter