Search results

I have searched all over the forum and can't find help on this one. I have a sub report (InvoiceTimeSub) that has 3 exp fields. The 1st one multiplies the reg hrs worked * reg pay rate, the 2nd one (exp2) multiplies the ot hrs worked * ot payrate and the 3rd one (exp3) multiples exp2*exp3. On...

I figured as much but I'm not sure how. Also....I have it automatically looking up the reg rate and the ot rate based on the selections in the combo box but it doesn't seem to be storing them properly.

Thanks....I'll see what I can figure out. I've been working off of their time and billing samples but the problems is, it's based on 1 billing rate per employee and we have 2. A regular rate and an overtime rate and it is confusing the HECK out of me!

I posted in General but I think this may belong here. Basically I have a time table that has a work order ID, employee ID, reg hours, reg rate, ot hours and ot rate. I want to add 3 fields regtotal (this should multiply the reg hrs worked by the reg rate) ottotal (this should multiple the ot...

I have FINALLY gotten my timecards & expenses working however, I need to make an invoice out of them and I am not sure here to do the totals. For example.....I need an invoice that will look like this Date Employee Reg Hrs. Reg Rate Reg Total (This should multiple hrs & rate) OT...

It helps a BUNCH...thanks, I'll try it out!

I am trying to create an invoice report. I have a table consisting of a combo box to select the job, a combo to select the employee and a column for regular hours and a column for ot hours. I then created a query by job and it displays all time partaining to that job, the date & employee. I...

Thank you SO VERY MUCH! I'd give ya a big squishy hug if I could!!!

I GOT IT! WOHOO! I GOT IT!!! I put this expression in the query: Expr1: [BillTo] & " " & [Attention] & " " & [Address] & " " & [City/State] & " " & [Zip] Now.....this SHOULD be a simple question...ho do I insert commas in there to separate the fields?

Yes, Ancient One...that is EXACTLY what I am trying to do. Thank you so much for the explanation. I am having trouble getting the query set up. I have added the joined column to the query.....but what makes it actually join them? I created a query and added a joined column to it but now the...

I don't know where to go do that at...also, my fields aren't coming from a query. They are coming from a table. They are all displayed in the combo however, once selected only the 1st column is displayed. I want them all to show.

This looks like the solution I may be looking for....but how do you cocatenate them?

I can't figure this out yet!! HELP! What am I doing wrong?

THANK YOU!

Does anyone know of a good site w/example databases? I am trying to make one for our company that will do jobs, billing, track employee vacations, inventory, etc. Thanks!

Mine displays as an icon. Ho do I make it display the photo?

The wizard didn't ask me that. I am using Access 2000.

It would help if you could post them here. :)

I want to add photos to records to display in the form when the record is selected. Such as select the employee and have his or her photo appear. Does anyone know how to do that?

Ya lost me! Not that it's hard to do!