Search results for query: *

I'm trying to run a query and am getting the error message "You tried to execute a query that doesn't include the specified expression as part of an aggregate function or grouping" I've been all over the net this morning and can't find something that will help. Here's the scenario...

I have a database that is being used by bill collectors to collect on accounts. At the end of each month, through the use of a combo-box, they designate for each account whether they would like to keep it or get a new one. They are only permitted to have 10 accounts at a time. I currently...

I have a corrupted database that I am trying to recover but am running into problems. I can't import anything from it. At all. All I get is the same error message. There are no *.ldb files out there. I also have disabled the AllowBypassKey function. Could I ever recover it or is it gone...

Is there a way to do this? I set up this function but Access asks me to define "Tables". I don't think this function is meant to work with tables but I don't know what else to try. Can anyone help? Function FormatValue() As Integer Dim val As Variant val =...

I don't think this is possible, but I'll ask anyway... I have a pre-formatted, 2-column table that looks something like this.. 101 1 # 2 # 3 # 102 1 # 2 # 3 # 103 1 # 2 # 3 # etc... I need to summarize 1,2,3 based on the value that precedes them (i.e. add...

Hey all.... I have a table with payment fields (pmt1-pmt12) and date fields (date1-date12) for several thousand accounts at a collection agency. I want to make a query that selects only payments made within a given date range. A payment can be in any field. My problem arises with the fact...

I have a query (linked to a command button on a form) that is supposed to search a table for a name value. Because the names are either "FirstName MI LastName" or "LastName, FirstName", I need to search for the value in any part of the field. My criteria looks like this...

I have a report that I am making for our collections department. I have a 2 tables, "promises kept" and "promises not kept" (we're finding out how many of those checks were actually in the mail). I use two queries to summarize data from each table. The queries work fine...

Hello all. I have a report that needs to be sorted by a different field than the group. In this instance, it is grouped by "AgentID", yet I want to sort by "Department" and "Name". Setting this in the sort and group field does not work, it still defaults to sort...