Search results for query: *

I have a table that has multiple fields with names that end in a specific string, e.g. "net" and "exp". I need to come up with a way to add all the 'net" fields in a row, as well as all the "exp" fields. These two totals will be updating the last two fields in the table. I'm looking for a way...

I had this problem long ago with WSS 2.0 and solved it, but I cannot find the setting in WSS 3.0. My Links List on the front page will not expand past 20 items, instead giving me the "More Links..." link after the 20th item. So I have items 21 and 22 that no one can see without opening another...

I'm attempting to print data from a gridview to a Dymo Label Printer via Client-side Scripting. I'm getting an error on line 9: "Object doesn't support this property or method". I'm trying to pull the data into a string value to feed to the printer function. Here is my page code: <html...

I have to calculate how many days from the last day of the previous month a certain date was. I have a table that contains the last activity date, I need to calculate howmany days between that date and the last day of the previous month. I'm drawing a blank here.

I am building a table of totals that are rolled up from groups. I can get all my totals into the table by looping through a rs that changes my sql and then appends the results to the table. I have 2 fields that I need to update on each loop with the values from my rs. I cannot seem to get it...

I have a table with the following structure: Sortcode | Merchant Number | Item1Count | Item1Cost | Item1Exp | Item1Rate | Item1Net etc.. There are several Items (they are not named this way, this is just an example), The key field does end in "Net". I need to create a report that will display...

I have a table I am trying to do some mass updates to. It has an ItemID field and a Yes/No field. I am trying to set the Yesy/No field to Yes where ItemID is one os several values. The update query runs with no errors but doesn't affect the table at all. Here is my code: UPDATE AgentItem SET...

I have two tables: "sortcodes" with fields "agentname" and "sortcode"(Unique Id), and "tblitemlist" with fields "itemID"(Unique Id), "itemcode"(Short Description), "description"(Long Description) and "Income/Expense"(Binary). I need a form that will have a drop down to choose the "agentname"...

I'm not sure if this the proper forum or even a good subject. I generate reporting every month for a credit card processor. These are Settlement Reports they use to pay the independant sales agents. I am trying to revamp the whole system from the ground up. My existing process consists of...

I tried to do this in the make table query, and while it displays as currency, the field data type is text. I have 4 problem fields that are created while wrapped in FormatCurrency(). Table is MerchantSettlementPage1, Fields are SPS, Gift, MonMin and Fee. I know I can go manually change the data...

I have a query that returns a bunch of data by a unique ID. I need to filter it for a report so I get a total that is a calculation of certain ID's. My problem is I need to get 2 different subsets, while leaving out 2 sub-sub sets of one of my sub sets. Here is an example: My UID field is...

I have posted this to the forms forum, but I am posting here as it has gotten to be a code problem now. I get this error: "Invalid use of '.', '!', or '()' in query expression 'newagentlist.* where newagentlist.[agent code] = " & "CBL - Agent 144"'." On this code: strSQL = "Insert into t" &...

I need a push button method of cloning a record. I want to give my end user a simple form to choose a record by choosing the name of an agent from a drop down, click a button which should copy that record from the underlying table and then present two text boxes that are populated from the new...