Recent content by wayney2507

Ah I've just found this can be done by running a report and just grouping by route code. I guess that does the job :) Any other simple solutions welcome though!

Hi all. I have a simple database set up containing the following: Origin City, Destination City, Route Code, Price I have a form set up with two input fields to enter two cities, and a button to run the query based on those entries. This works great so far. But what I really want is to...

I have a button called "ViewLetter" on a form. I'd like this to open the document located here: C:\Documents and Settings\home\My Documents\Random Docs\letter.doc Any help appreciated.

Parameter Queries used instead.

Ah i found out how do it the easy way. Make a 'delete query' using criteria "<Date()-90" Thanks for the help though.

I have a table "Jobsheet" with a field "Date" within it. I'd like to put a button on a form so that when clicked, it deletes all records with a date which is 90 days older than todays date. Help please?

Just wana search a table by the "Date" field for the last 7 days. When I open the report based on the query, it will show the last 7 days of records, without having to keep editing the criteria. Criteria: "Between Date()-1 and Date()-7" This works perfectly, but I'm, just wondering if...

I can assure you that link is safe, mediafire is quite a well known filesharing service and you can see that it's a .db file. A solution to this is pretty urgently required if anyone can help pls?

If you'd like to download the database so you could understand what I'm asking and help me: http://www.mediafire.com/download.php?zvywan4nrzr Ok so I have the form "Jobsheet" for the table "Jobsheet". I want the cost to automatically display if I pick the destination from the drop-down menu...