Recent content by RevDocJeff

Is there a way of querying for an astricks? Some data in one of my tables has data that looks like this "A*" or "B*" or "C*", but most of the records are just "A" or "B" or "C"...I just need a query that I can pull out those records. Is there a way of doing this in a query? Thanks

Ok, but I'm trying to figure out how to specify the file name and location in code. I have about 20 reports that I run daily and for each one I have to open it up, print to the adobe printer, and specify the path and name. I want to be able to do all this in code. The path will be the same...

How can I specify an adobe printer and the variables it asks for, ie. file name, location..., when printing a report using a module? Thanks

I'm trying to count the number of business days between two dates. I did a search in help and it came back with "NETWORKDAYS()" but that isn't a function in MS Access. Does anyone have and suggestions or ideas for solving my problem? Thanks

Hi, How can I determine, through a query, the latest date in a date field for a table. The table has two fields. The first is Ref_No, the second is Rec_Date. Ref_No Rec_Date abc-1234 01/01/04 abc-1234 01/08/04 abc-1234 01/05/04 bcd-2345 02/17/04 bcd-2345 02/07/07 bcd-2345...

How can I link images to records and have them show up on a form? Thanks

Ok, I took the memo fields out of the union query and then created a new query to put them back in. That worked within the the query, but when it's put into the report, the field is still cutting it off after 255 characters. Is there anything else that I need to do. Thanks

I'm running a Union Query from two other queries, both of which have a matching memo field in them. The Union Query runs fine, except when the Memo Field in involved. It cuts off the field after 255 characters. Is there a way to fix this? Thanks