Hi all, I have a table with various info quotation files (Customer Quotes). The key field is Quote ID. I have another table with specific detail...

I have a field defined as a memo field. Yet, when I display it on a report, it only prints 255 characters.

Thank you for those that answered my first question, I think I may have outlined what I wanted incorrectly. I need to list telephone directories by zipcode. ...

I have a report based on a query with 2 separate expressions contained within. When I run the query the expressions run fine and I get the data requested. ...

I'm trying to do a statement to group categories based on less/than values (see below) If I only do and no =, then all values will be "4". How can I...

I have a report ,in which some records may have a comments field. Is it possible to have this comments field displayed at the report footer,only for the...

I currently hold sales data which is grouped by WeekNumber as follows; WeekNumber, OrderDate, Rep, ContractValue WeekNumber is in text format and OrderDate...

I want to open a report preview from a command button on a form and have the report preview window maximize and the report fit the window. I can't remember...

I have several records and each record needs a different number of copies printed. I have the number of copies in a field and would like to snd that to the...

I have a report that reports on company orders and includes the following: CompanyName,Item#, Quantity, lastorderdate, average days between orders and next...

I have a database that I need to create multiple labels with different criteria. I’ve used label wizard for all my addresses but what if I want to make...

Hi. I have a report that shows the facilities we visit throughout the month. There are days (Mondays, MWF), times, times a week (1st Monday of the month,...

In a report, I am getting "#Error" in one of my fields, and I can find no way to make it tell me what the error is. What can I do to make Access97 tell me what...

I've been struggling with this error for a while now...hope someone out there can help. I have a form where the user would enter the parameters for a...

Bill I seem to recall a DayOfWeek-like function. If you find that one in Access HELP, then use the Left() function to show the left-most character,...

Hi I've a table with par example 3 fields: Shop, Number1, Number2. Like: New York 12 8 Paris 69 15 Brussels 50 2 I want to sort a report...

I downloaded from the Web a inventory DB called: 01018458.mdb , been using it for a while, modified it a bit to show better results in the reports area, but I...

Hopefully this post doesn't get too long but I want to give all the info I can. :-) BACKGROUND: I have an DB with 1 table that keeps track of 1/2...

Hello, I have a report that is made up of a summation of several tables, each with one or two matching fields. The result is a summary table with...

I am working on a database which formats output files from the mainframe and translates the coding and billing information into a customer-friendly statement....