I've written the following statement and I'm getting the following error, the expression you entered has a function containing the wrong number of...

access 2003 In a report I need to show all records except the last one. How can I edit the query to show all except the last one? thanks -- deb

Hello folks, I am trying to exclude record from a query that start with a letter followed by the underscore and other letters....

Hello- I have a form that is used to update records in an table. The table has a field called "RecordUpdated" that gets a date from the form when the form...

hello! I have 3 tabels: 1. Rooms-list of rooms 2. Document-list of orders 3. RoomsInDocument-list rooms in one order I am trying to create query that show...

Hi, I have a field called TransDate that is in the format 01/01/2010 and I want it to look like 2010Jan. Is there some way to combine the Format function or...

I have four fields in a table that contain an identifying number. I want to write a query with an expression that looks for the first field that contains a...

I'm have 2 tabels. The first table have list of rooms and the second table have list of orders of customers(content RoomId feild and the fields incoming date...

I'm querying a MS Share Point list and need to strip HTML from the query results. Is there a way?

I have a table with 36 rows containing the field, FiscalYear, values, 1,2 or 3, and EndDate, containing month end values for 3 calendar years, for example,...

Hi, I have data based on test results. My data is in 3 tables as listed below (I'll only listed pertinent data for this action): Table 1: Time Table 2:...

Good Morning, I have come here for help a few times but due to security access at the time I was unable to post the info needed to get my issues resolved. I...

I have 2 tables in Access, one holds Clients Initial Details, the other holds a record of each time they are contacted, how can i pull the most recent contact...

Hi, I am running a query based on 3 queries q1 has this PurchDoc Item Rel Vendor Vendor name Order Type PO Date Material Short Text MRPCn Del...

Help, I am working with make table queries. I have a A make table query and a B make table query each with various information that the query has...

Hi all, I am using MS Access 2007 as front-end and SQL Server 2005 as back-end. In SQL Server I have a PK plus a multi-field index that is unique. I can add...

hello gurus I have a Report based on the Cross Tab query shown below: TRANSFORM Count(qryEmp.SiteID) AS CountOfSiteID SELECT qryEmp.SiteName,...

could someone please tell me how to write the criteria for DSUM where the first criteria is date1 date 2 and the second critera is date 1 = date3 I'm...

I have the following 3 tables Parts1-------*PartStyle*----------1 Style PartNo PartNo StyleNo Price StyleNo ...

http://find-stolen-laptops.com/wp-content/uploads/2010/03/never_know.jpg Use Snuko Anti-Theft Software to trace your lost or stolen laptop. It's easy to use,...