Search results

I have a report that I have a group for the [PROD] field. I have a query that says: ((tblScaleData.PROD)='Veg1' Or (tblScaleData.PROD)='Wood1') Or (tblScaleData.PROD)='Vegr') but I need Vegr to not show up in the group, but I need to add the weight associated with it and then subtract that...

I tried =Mid([Ticket],3) but I got a; 'Syntax error (comma) in query expression' error. When I created the report I chose 'Ticket by 3 Initial Letters' option for my Grouping. I looked at that and it has; '=Left$([Ticket],3)' in the Control Source property. So I tried; '=Mid([Ticket],3)'in the...

Ahhh! I knew that.<grin> Thanks for the reminder.

I have a database that, when created, someone made one of the fields by concatinating two fields from anotehr table as it was imported into Access 97. Now someone else needs one of the columns to be data from the right field 'before' the concatination. Is there a way to say exclude the left...

I too am probably guilty of coming here too much. I find On-Line help dificult to understand. The answers here save time, they are in English (as apposed to pedantic) and sometimes they come with a 'watch out for' or 'but don't...' which HELP would never do. I don't feel guilty cause I've...

okay I did it, but I needed the two SQL statements listed here. Is there a way to link these so there is just one statement? First I did this: UPDATE [APS Import Test] SET [APS Import Test].[Rate Code ] = IIf(Left([Rate Code],2)="E-",Mid([Rate Code],3),[Rate Code]); Then I did...

I have data in a field that looks like this: E-221 RATE OR E-32 RATE. I need to get rid of all the text. I tried variations of this: UPDATE [APS Import Test] SET [APS Import Test].[Rate Code] = Right([Rate Code],5)="" WHERE ((([APS Import Test].[Rate Code]) Like "*RATE*")); but I keep getting...

cool! that was it. Thanks

okay, here's the answer: =Month([DateIN]) - then each group (grouped on the date field, which in this case is DATEIN, but it groups on the Month portion. The only problem is... it returns the number of the month i.e. 7 for July, 8 for August. Anyone know how to make the word appear rahter than...

Pat: You were right, I changed the name of the textbox to txtNWT and then it worked. Thanks Old Gnome: This works - it seems if the textbox is the same name as the field Access thinks the textbox is refering to itself and it gets confused.

but I don't have a 'month' field, I have a 'Date' field. So I think I have to break the month part of the date out of that field and group on that, but it's not letting me do it.

I need to create a report that groups by the month portion of a Date field. I tried: Left([DATEIN],2) in a query to see if I could get the month part out of it but I get a 'Datatype mismatch in criteria expression' error. Is there a way to do this so they can get the data separated by month?

that was it. So close, yet so far away<grin>. Don't cha just love the easy ones? Thanks

no, I'm just trying to get the amount in the NWT field divided by 2000 in the Detail band of the report so if they need to they can see th individual amounts. Then in the footer I will have =Sum([NWT]/2000).

that was it. I thought is was probably something simple. Thanks

can you hide the Detail band of a report? If so, how?

in the Detail band of my form I have =[NWT]/2000 in a textbox called Text19 and that works. Then in the footer I have =Sum([text19]) but I get #Name? What am I doing wrong?

This should be an easy one (famous last words) in the Detail section of my report I have =[NWT]/2000 in the ControlSource of a text box but I get #Error. Then I tried =Sum([NWT]/2000) but then all the answers are the same number. The first formula works in the form okay but not in the Report...

>>You need a group by clause in a totals query Ah, that was it. I added a 'Totals' line and put "Expression" in the Expressins columns (interesting how that works<grin> ) and Group in the grouped one and "Where" in the ones that were just plain fields. and it worked. Thanks

I tried to create the following query: SELECT Sum([NWT]/2000) AS YTDNWTons, Sum([CTOT]) AS YTDAmount, Count([NWT]) AS [YTDNo of Customers], tblScaleData.Ticket, tblScaleData.PROD FROM tblScaleData WHERE (((tblScaleData.Ticket) Like "sc1*") AND ((tblScaleData.PROD)="VEG1" Or...