Search results

Make a report form a query along with Date criteria. There a plenty of examples in this forum if you search filter report. hth, Michael

Sharon, I suggest you attach your file to winzip. Also, it appears that you might need to make a cascading combobox along with IIF and Switch Functions. hth, Michael

Check the link below... http://www.access-programmers.co.uk...ead.php?t=75790 hth, Michael

Take a look at the site below. http://www.techonthenet.com/access/functions/misc/curr_to_words.htm hth, Michael

Make a field name in a table - Data Type will be number and Format it to long interger and set your default value to -1. When inserting your field in a form be sure you set it to a checkbox field instead of textbox. hth, Michael

Open your table where currency field is located and change it to 0 instead of Auto in decimal places. hth, Michael

The #Error error value means that Microsoft Access cannot evaluate an expression. For example, you may have supplied incorrect or too few arguments for an aggregate (totals) function, you may have used a parameter query as the domain for an aggregate function, or you may have made a circular...

You can do 1 of 2 things either making a query for vessell search or make a cascading combobox. hth, Michael

Seems like you looking for cascading combo box search. Take a look at the attachment file... hth, Michael

Go to view . . . Sorting and Grouping . . . Select a field you wish to group either for header or footer. hth, Michael

When using a short date for crosstab query it will not allow you to enter dates parameter. I sugguest you use months instead of short dates. hth, Michael

Try Date() instead of Now() hth, Michael

Try this .... Dim strDocName As String Dim strLinkCriteria As String strDocName = "ReportName" strLinkCriteria = "[FieldName] = Forms![FormName]![FieldName]" DoCmd.OpenReport strDocName, acNormal, , strLinkCriteria hth, Michael

Take a look at the attachment file - it a little different from what you want, but you can play around with it. hth, Michael

Try making a report from a query...and from there you can select a field that you to be in ascending/descending order. hth, Michael

I suggest you make a crosstab query.... The only bad thing about making a report to look exactly like your excel is you have to many fields that will make you report print more than 1 page even if you use landscape. hth, Michael

Try this.... If your letters come first use right function... Right([fieldName],9) If your numbers come first use the left function Left([StockNumber],9) hth, Michael

No Problem :) Michael

I suggest you give us more information on what you want us to help you with. I know you're trying to get the total for something, but give us the field name, report name, and/or subreport name. We need a better explaination on exactly what you need. Maybe myself or others can help you out. Michael

Not the answer I wanted to hear, but thanks I kind of figured my database was some what corrupted. Michael