Search results

Hi Rich, I do have an employees table. On my form that my report is based on has "EmployeeID" on it that links back to this table. However on my report it comes up with the employeeID number rather than the name. I dont know how to change this to read expression you gave me that will give me...

Thank you for your reply Rich and I apologise if Ive confused you. Unfortunately I still am. Hopefully I can do better at my describing my problem. I have one Order Details table. I have a subform(Order Details subform) that allows me access to the fields in the order details table. From this...

Thanks for the info Chris, but when I put that expression in my report, when I go to view it, a box pops up asking for the first name and last name??? Did I do something wrong?

Can you please tell me the expression I use to join the employees names together in a report. In the Employees table they are entered as first name and last name. Thanks

I am working with the template "Order Entry". I need to put a description field on my report that is located in a table in "Order details". However when I try to put the control in, it doesnt give me the option. I created a query but it does not give me that option either. I will give me the...

I would like to set up my present form so that when I select a product from a list it will automatically put the pricing in. All the pricing would be from my products table. Can anyone tell me how to do this as Ive tried many things with no success.