Recent content by Deb in LA

There's probably a better way to do this, but this is what I ended up doing : =IIf([transamt],(Left([balfwd]+Sum([transamt]),(InStr(([balfwd]+Sum([transamt])),"."))-1)) & " DOLLARS AND " & Right((Format([balfwd]+Sum([transamt]),".00")),2) & " CENTS",(Left([balfwd],(InStr(([balfwd]),"."))-1)) &...

My text box has this in the control: =IIf([transamt],Format(([balfwd]+Sum([transamt])),"#") & " DOLLARS AND " & Right((Format([balfwd]+Sum([transamt]),".00")),2) & " CENTS",Format([balfwd],"#") & " DOLLARS AND " & Right((Format([balfwd],".00")),2) & " CENTS") When I test the report, the part...

Try this: =IIf([RESOURCE TYPE]="EMPLOYEE",([Sum Of BILLABLE HRS]),"No Billable Hours") Iff statements are like saying if this do this else this. Missing the else part could be the problem. Try the above and let me know if it solved your problem. Deb

If you want them one letter on top of each other, put a s p a c e between the letters and adjust the box vertically. It should wrap into one row. Or can do it Illustrator or Photoshop and put it in as an image. Hope that helped. Deb

Hi everyone. I went to this web page and followed the directions, but it does not work: http://www.mvps.org/access/reports/rpt0013.htm I have an unbound textbox in one of the group headers called "GrpPgInd" by grouping field is called "PTNum". I have replaced the code where asked for at...

Sorry - wasnt done... :P Then for example the new column is SumOrders: sum(orders)in your query, Then in your report, SumOrders is in the group footers for each order. Then in the report footer, sum(SumOrders). Deb

Can you put a new column in your query and have a sum of the total orders in the query? Then put that field in the appropriate footer sections? Deb

Sorry - any VBA coding on on format events for group footer that contains the subreport do not work.. if anyone can solve this would be a miracle!

I'm not sure if this is what you want, but if I'm understanding you right, you want a user to type in a date then your query runs based on that date and returns the age. Have you tried to create 2 unbound fields on your form for the user to input a date the other does the calc? You do not need...

Can try this: If it's an unbound field, in the format line, do not pick short date, can type in mm/dd/yyyy or mm/dd/yy. If it's a field bound to a table, you can chose short date then put this formatting in the input mask area of the table def to this: 99/99/00;0 If the form is referenced to...

Think perhaps your assignment tables need a diff primary key. The ssn primary key field in all of your assignment tables should be foreign key fields which link to the student table via the ssn number primary key field in the student table. The primary key field in the assignment tables could...

Thanks -- I will give it a try next week--I never thought of capturing the Windows login id. Deb

Thanks. Split the database...hope you mean load the program on their local drive and place the data on the network. That's what I was planning to do. Let me know if this is wrong. Deb

I'm sorry - I didn't understand.. where would I put the code you had mentioned? In the on format event for the group footer? 'For the header: Me.Section(5).Visible = False 'For the footer: Me.Section(6).Visible = False And will that just make the header and footer not visible? Wouldn't it...

If you can separate it, you can put it back... lets say that field1 changed with this: left([field1],5) That will give you field1 without the bad ending. Try left([field1],5)&"J20L" in your append query - try displaying it first -- it should take the 2 parts and put them together...