Search results

Hi, I have 2 queries, one showing returns with dates and the other showing sales with their sales dates (both have item number, customer name and sales person's name). For each entry in the return data, I want to find the matching sales date in the other query. I tried using the Dmax query with...

Hi, I have a list of client activity - client name, loan ID and loan date. I would like to create a new field that shows the number of days between one loan and the next. If I was doing it in excel, I would need to sort the data by client name and loan date and then calculate the number of days...

Hi, I have been trying to import and append data from an excel file into access and keep getting the message "The connection for viewing your linked Microsoft excel spreadsheet was lost." I have tried several options including: -saving the data in a new file - checking to ensure that the field...

How do I delete duplicated records without having to make a new table? I would like the records deleted from the original table. Thanks

I have two tables: the first has sales information by item number and date (and other information) for a particular period the second has item number and item description (it is a comprehensive list of all item numbers). I would like to put the item description into the first table, by matching...