Search results

Using Access 2000 I have a field which lists a date. I would like to determine which financial month the date is. However the financial month starts and ends at odd times, for example The start time of the month is the first Sunday after the last Friday of each month. With the end date being...

(Using Access 2000) I have two tables, table 1 lists bid details, and table 2 lists project details (if the bid is turned into a project). They are linked via the project number. If I use the wizard to create a form, where it creates a bid details form and then a box which pops open the...

I have three tables Company, Customers, Order Details One company can have multiple customer names. Customers can have multiple orders. In the order details table I have a lookup field to the customer name/company id to say which company/customer the order is associated with. I wish to create...

Hi, Don't know if anyone can help. I have a database which records survey data. Each location has a unique identifier for which the measurement data is recorded. The direction of measurement at the location is also taken. From the measurement data some fancy calculation happens and it gives...

I have a query which combines three tables of data. There is a location table which has details of the item - which then leads to another table based on the items at that location. The locations are unique and would never need to be added to. For each location you can have multiple items of...

Hi, I haven't too much experience with access. I have a list of measurements, and the dates on which they were measured for a certain item. So I have multiple measurements on different dates for each item. What I would like to do is create an x-y scatter plot of date (x) against...