Recent content by ITlori

YES! Thank you, I've got it working now. What's more, I actually understand what I did! PHV, thank you for answering succinctly what I was trying to figure out all morning. Lameid, thank you for helping me to understand how to do this query... very much appreciated. [bigsmile]

Hi Lameid, This is great. I did not know about grouping for multiple fields that way. In using your SQL with the Inner Joins, I am struggling with where to put the parentheses! (now I know why I resist using Joins!). I am getting all sorts of syntax errors. Help greatly appreciated! Lori

Hi, From a form, I want to copy a photo (jpg) from a user's source directory and put it onto the database's server. I set up a common dialog so the user can "browse..." for the source photo. But now how can I save the photo into the destination folder? Are there VBA commands to do this? I...

Hi, I have a report that displays summary information, summing prices for all records for a RoomID meeting certain criteria, and printing the roomID and sum on a detail line. Now I want to add lookup-table info onto the detail line. The report’s query determines what items are missing for a...

Hi, I need to add photos to my database. Back End is on MS SQL Server (I believe 2000), and Front End is on MS Access. I have read about storing the photos as BLOBS, but I am not sure how to do this with SQL Server. Does this mean store the photo as OLE image, but do something else to it to...

Hi, I have a report displaying items that are missing from a room. I created 2 queries, the first getting the items IN the room, and the second being an "unmatched" query that references the first query where Item is Null. I use a subreport for the details, and the results display correctly...