Recent content by complexx

Problem solved. Thank you Shudini.

Unfortunately that didn't seem to work either.

It has to be something else. The only thing I change is adding TOP 1. It works when its simply SELECT blah blah blah, but when I try to SELECT TOP 1, it returns no results.

I feel like I'm misunderstanding something basic here. I have a report that lists systems for my desired customer in the detail. I leave some blank space next to the system name so that my techs who are out in the field have room to write in data by hand for their service. next to the blank...

Oh is that bad? j/k I'm using Access 2003. When I open a query in design view, there are 15 fields that I can specify. I'm not trying to query 255 fields, more like 20 or 25. How do I enable more fields to use? *Edited for comic value.

I'm trying to build a form based on a query to use for data editing/entry purposes. The only way I can think of to do this is to use a query to get data that is particular to my specified customer. The first problem I have run into is that one query does not contain enough fields to retreive...

report not updated if data is changed if I have already entered a specific route into my data base with customer X in it, and then decide to change some of the data associated with customer X, these changes are not reflected when I preview the report. However, if I create a new route...

I realize I forgot to mention that you could have multiple data on the same date for one customer. How could you add the RECORDID to the select statement you posted above so it selects the RECORDID that has the greatest value in addition to matching the Customer name and date.

In order to find the most recent piece of data for a particular customer I need to query my table in 3 iterations. I have a TABLE with data in it pertaining to all customers. QUERY 1 orders all the records in TABLE by date. QUERY 2 plucks all records related to specified customer from QUERY...

DOH! Thanks for the assistance. I'll make the changes on Tuesday when I get into the office.

my file is somewhat large can you PM me your email please? I recreated the tables in the backend and tossed them into a copy of the front end for you. I tried to strip as many tables/data as I could to compress the file but its still too large. Please take a few things into consideration...

I'll try to put something together for you to look at. The DB is split and I haven't been the most organized when it comes to labeling.

I'm trying to implement this the way you have shown me in the sample however I'm getting an error when I try to view the report. My database is access 2002/2003 format, I have a feeling that has something to do with the problem. The error I get is on the line of code that you quoted in your...

Bob, your one crazy access programmer! Thank you for the help!

What I'm trying to do is a bit more complicated. I'm only looking to print out 1route at a time. However, if that route has for example, 4 stops, it should print out 4 pages (each page has information for 1 of the 4 stops). The important aspect for me, is that each page only has information...