Search results

I have a database of service requests. Each service request is given an entry date. I need a query to tell me if we have 3 requests for the same service within 30 days of each other. So, the 30 days is a moving target. I don't want 3 requests within a specific 30 day time frame. Any ideas on...

I am using the following in the control source of form2's Lname field: [Lname]=Forms![form1]![Lname of form1] However, if the user came to form2 by way of the switchboard or if Lname was blank in form1, I want the user to instead get the prompt [Enter Last Name]. How can I ammend the above...

I am designing a db in access97 for several users. Problem is most users work from a field office and are not constantly connected to the network. (don't ask why - this is city government). If I copy the db to each of their laptop hard drives, is there a macro I can give them that will save...

I have a query which powers a form and a report. The query has a parameter requiring the user to enter [fieldname]. I want to put a command or macro button on the form which takes them straight to a print preview of the report, but I don't want them to have to enter the [fieldname] again -...

I am designing an expense report where one column in the detail section is the running sum of expenses for each account[sumofaccount]. I now want to put a formula in the account footer that calculates [appropriation]- [sumofaccount]. But instead of the final running sum number, the report...