Search results

Hi Is there any easy way to grab the field/value pairs used in a filter by form? I suppose I could parse teh filter string, but if there's and easier way (or if there's a parse utility out there) it'd be great to know. I'm using Acc2000, if that helps. Many thanks Richard

Hi I am currently developing a sales tracking database. As part of the reporting function I need to generate a graph showing number of sales, cumulative sales etc for various time periods (week, month, quarter, year). What with the current state of the economy it is just possible (:D) that no...

Hi Sorry if this question has been asked before - I've searched but can't find anything. Anyway, I have a report whose records are filtered by a preceding form. I'd like to display a small (subreport?) which displays which fields have been searched on and the values entered by the user. Any...

Hi Apologies if this has been answered before. I've tried a search, but not sure which keywords to use :( . I have a parameter query driven from a form which returns records into a list box programatically, using a call-back function. It's all working fine, but now I need to add an extra...

Hi I need to be able to write a forms recordset to a CSV text file. I belive I have to open a file and then loop around the fields, writing each fieldname. The 1st bit of code (contains the fieldnames themselves) looks like this For i = 1 To UBound(arrFieldList) Write #1...

Hi I think this is the correct forum to place this question - apologies if not. Bascially teh set-up I have is this. I have to produce a graph showing quarterly numbers for a (varying) number of regions. Unfortunatly, some of the data is missing. I can interpolate this missing data by using...

Hi I wonder if anyone can help me out on a db i have inherited. Basically I need to add a field to a table and backfill the field with a number depending on a date field. The new field (CallID) needs to record the order in which calls are received on a certain date (CallDate in the table). So...

I'm sure there must be an easy way to do this.. I would like a report to list company financial information for the past few quarters (haven't decided yet, probably 4 or 5). I would like the structure below June 05 Mar 05 Dec 04 Net Income...

I wonder if anyone can help me with this I have a table, let's call it "Payments"which records customer payments in each period. What I'd like to do it is write a query which shows what percentage of customers who make a payment in period N, also make a payment in period N+1. Basically I want...

I would like to use the access enter parameter value dialog to return records where the field is NOT equal to the paramter value. So, for example I would like to return all pupils whose name is not "Smith". Is this possible? I've tried entering directly into the dialog, but get an error...