Search results

hmmm, okay thanks. Any suggestions where I can get any ideas about them?

>>Is Bill To Date an actual Date field? yes

I work with a couple people who do some programming in Access. They both have queries that reference other queries. To me it seems like spaghetti code. What's the scoop on that? Is it acceptable or bad form?

okay, I tried to get rid of all t he stuff I don't understand anyway and just tried: Group By Month([Bill-To Date]) but I still get; "You tried to execute a query that doesn't include the specific expression 'Bill-To Date' as part of an aggregate function." Does that make it any easier to...

I took out the: 'MMM \" & InsApos() & "YY' and put in: MMM"\"YY and I get "Type Mismatch" error. thinking that I misunderstood,I tried: MMM" \' & InsApos() & '"YY))" and I get: Complie error, expected expression. So do I still not understand what you meant?

Harry: Thanks for the suggestion. I tried the double quotes: (Format([Bill-To Date],'MMM \" & InsApos() & "YY')) and I get the following error message: "Syntax error, missing operator in query expression" If I use single quotes: (Format([Bill-To Date],'MMM \' & InsApos() & 'YY') I get the...

I'm getting "syntax error - missing operator" with the following code. I think the problem is in the GROUP BY part. I copied it out of the ROWSOURCE on a Chart and it had "MMM \'YY" but the double quotes won't work in a SELECT statement so I had to change them to single quotes which I think...

Im having a problem similar to Nancy's back on 8-7-2000. I did a search for "Chart" and her's was the closest to my problem but the solution wasn't there. I created a chart on a report and on a form and associated each to a query. When I double click either I get a prompt to enter the begining...

fixed it. I had the summing control on the subReport in the Page Footer, not the Report Footer. Thanks anyway

okay, sorry. I had, I thought, a valid reason but I won't waste time with that. The solution you gave me doesn't appear to work with Reports. I tried: =[Sub Table Subform].[Form]![text14] on a Form, which works great but: =([Sub Table Subreport].[Report]![text16]) on a report doesn't work.

perfect! thanks a lot

I have a textbox on a mainForm called TotalTime in which I'd like to sum the total of the [Time Spent]textbox on all the subForm records, but just for the ID # of the mainForm. I tried: =Sum([Sub Table].[Time Spent]) (afraid that I would get the total for the entire table, not just that ID#) but...

why not use a calendar and have the visible property set to false until you need it. Have button that make it visible, then after you use it set the visible property back to false

how about having two comboBoxes, each linked to a different query or table that has the different caagories you want and then have a select statement like this: SELECT * FROM [weekly sales] WHERE (([weekly sales].market)=[Forms]![Query menu]![combo7]) AND (([weekly...

This probably won't be comforting but, I'm having a similar problem. The following code works BUT... I get a null if there is a divide by 0. That's sort of okay. I'd rather have a 0 than a null, but I'll take a null over an #error or a #Num! =Sum(IIf(Nz([Prod_List] Like...

I think I understood the explaination about why Avg() wasn't working. The Avg funtion wasn't looking at the records selected by the IIf Statement it was looking at the whole recordset. I think I need to clarify something else though. I was using the IIf because I need to get Like "*Compact"...

Pat: Once again many thanks for claifying that. I've since had to play with another one that was complex (for me anyway) and your explaination of that last one was a big help.

I just learned about subreports so I may not be on the right track here but what I read said to go into the main report and without highlighting the subreport double click on it. That opens the subreport just like the main one in design mode. Fortunatley for me I didn't have to do a lot, but it...

Pat:I got it working. I spent the last few hours learning how to add a subreport to a main report. I could probably make it prettier with more work but it's giving me what I need. Thanks

sorry, I'm not understanding. I don't understatnd how to use [Prod_List] like "*Compact" in the textbox on the detail band without the IIf and get the Weight. Also, I tried =Sum([Weigh_Net]/2000,0) in the textbox in the report daily footer and I got: "The expression you entered has a...