Search results

Thanks for the response. The concatenating of fields worked great!

Pat -- worked perfectly! Thanks for the help.

I have a report that pulls from 2 tables with the following fields: employeeid, lastname, firstname (table 1) date, hoursworked (table 2) I am trying to run a simple report that shows id, name and total hours for a given time period. in the report i need to group by employeeid, but want the...

ok, this should be very easy, but is not working out that way. i have a report that is based on a query that has a yes/no field. this field indicates whether or not the employee is entitled to an overtime meal bonus (working over 10 hours in one day). if yes, the box is checked in the form...

Hello. I know there is a way to take data from an Access query and have it automatically generate an Excel chart. I have seen it done, however, I cannot seem to figure it out. My VBA skills are NOT GOOD! Is there a quick and easy way to have a graph/chart automatically generate in Excel...

Hi there. I have a large form. Within that form there is a field where a user needs to enter a client contact name. If the name is currently not in the drop down (the related table) I would like them to be able to double click on the field and have the form pop up to enter the new client...

Thank you for the quick response. I am not putting this data into a form or report -- it is in a query that I am exporting to Excel. Think it can be done within a query???

Hi. I have a query that pulls multiple items, of course. Something like this: Name, IDNumber, Date, HoursWorked I have a parameter set on the date field so user can enter the date they want to run hours for. However, rather than have a heading of HoursWorked in the query results, I want...

Another Snag Hi again. Ok, I have the table that makes the conversion, however this is how it is structured (I have duplicates) Old Code New Code H001 ABC H002 DEF H003 GHI C001 ABC C002 DEF C003 GHI You see...

Hello and thank you for your response. I thought it was something like that and I did try that earlier. Just so I'm sure I understand: create the new table with only two columns; then create a query that contains both the new table and the original data table as well? Thanks.

Hi there. I am attempting to change the output in a query field. Meaning: if the equipment code=x,y or z, I need the query to print a,b or c. I know I have done this in the past but cannot remember how nor can I find it in help or my book. Any help would be appreciated. Thanks.

Is it possible to take certain data from an Excel spreadsheet (specific row/column) and then transfer that data to an existing Access db automatically -- meaning upon SaveAs can the data be transferred? Would this be done using a macro within Excel -- this is all new to me, any help would be...

Anyone know how to have fields automatically fill in on a form based upon data stored in a linked table? How to you specify where to go get the info from the table. Thanks.

Have a db that prints several ole objects on a report and currently have to store the ole objects in a field of a table in the db. Is it possible to print these ole objects (bmps) in an Access Report, without having the bmp's stored in the db -- want bmp's pulled from path name only. Just want...

I have this same problem -- could you please explain a little more. Group by -- what exactly do you mean? Thanks

I have just switched over to Access 2000 and am designing a db and ready to create the switchboard. When I select addins switchboard manager is not there. Did a complete reinstall and still not there. Any suggestions