Within one group I have, let's say, a return that starts with "A" and "B and "C". if the value starts with "A" I want to sort by field if it starts with "B"...

Hi there, I really hope you can help me! I have a database that has a bunch of names and dates, names of tenants, dates that they moved in, and moved out,...

I want to convert a field, in a record, with zero value to a null value: opposite of nz? also when using a calculation such as avg=() the null field should...

lxpbfjolhlkwjkhknyqifxdcjkbmvxrfcjekvkmrn

I want to add a group footer to my report. Right now I have a page footer, but I want something to print at the end of each group on the report. So I believe...

I want to make a report based from a query. The problem I keep running into is the information in the query comes from three different tables linked by a...

I have a form that requests a startdate and enddate for the transactions to be reported. In Print Preview, these two variables appear on the report header,...

I have a form called ticketbook. I have a command button on this form that I would essentially like to print a report and update a two fields in my table at...

I have a form called ticketbook. I have a command button on this form that I would essentially like to print a report and update a two fields in my table at...

I have a form to locate parts. I also have a subform linked to a different table to track when and how many parts were taken out of inventory. I want the...

I'm using Access 2002 and made up a report of my CD collection. I have records with fields such as: STYLE, INSTRUMENT, ARTIST, ALBUM TITLE, YEAR, etc.. I...

I have a report that is to look like an Excell spread sheet. Why, because they think it is the only way they can understand the data. Anyway, I do not know...

In a query I have this subquery PreviousOrders: (SELECT COUNT(date_purchased) FROM orders AS orders1 WHERE orders1.date_purchased orders.date_purchased ...

Hi, I am creating a report based on a query that contains an employee name, employee number, address, etc., plus the names of the employee dependents. If I...

For days of the week (not including Sunday) the field had numeric 1 or 2 or 3, etc. or combinations such as 13 for Monday and Wednesday. The database had...

I have a query that returns values for order in different states of completions for two different companies. For example: on 10/14 we may have 3 orders...

nuiwbqprbcnrflfkukcvuvtyxcrthgozdfkuxfngmjcynwpjpxxcuoigkuxpyhimmr

Dear Group, I have a 200 page report with 3 short subtables (1 master record per page). When I switch from design to page view (sorry, maybe badly translated...

Hi, Everytime I click finish after going through create report wizard.,I get an error message "The Wizard is unable to create your report". I have a printer...