When I run the report wizard, none of the fields in my tables or queries show up in the Available Fields box. What causes this, and how can I fix it?

Hi all, Is there a function to do decimal round-up in an expression Clara -- thank you so much for your help

Is there a control to get Page Headers to display on a subreport? I normally just put things in the report header, but if the subreport is multiple pages...

Hi, I have a report that contains a subreport, and it is based on a query. I use the Grouping an Sorting function to the define the fields I want to sort by....

Is there a specific join to bring in all data from two queries? Thanks, Melinda

Hi all, Is it possible to assign special null to a var in VBE. clara thank you so much for your help

I prefer snp reports since they are generally smaller in size. I have multiple reports that I generate and then save as snp files. Is there a way to...

Hi, I'm Jean want to know if possible to make to columns in a page on a Report. An example: Line Ticket Part Number Counted By Remarks ...

Hi, Im new at this and trying to create a report. I need on field to look up and count for a specific criteria. I cant make it work. Is it possible to...

My report (group header) code is running twice. Once when I generate the report and once when I print the report. Is there any way to tell which pass is being...

Hi all Is there a similar "Immediate Window" outside the VBE in Access to test function. The functions in Access are the same in VBE CLara -- thank you so...

I would like to make a report with one of the columns reporting data from more than one source. How do I make this work? Thanks for the help

Hi all, I have a report based on Table1 which has a field F1, how can I refer to F1 in the event of print of Detail Clara -- thank you so much for your help

I have a report There is a control box which is the concatenated first and lastname of a husband Next to it is a label with the word "and" to go with the...

I have created a report and added a subreport in the Design view. I have edited the view and when I preview the report, the subreport does not appear, only...

Hi all, I concact a string field in the my report detail print event, and display the whole string in a textbox in groupfoot event. If I narrow my form...

I am working on a report which is a log for charging indutrial batteries. It is a 2-page report. The first page is a report with 2 subreports. It is in...

am trying to build a database and need a query build to count times example Hound Number 999 score 35 Time 11:00 Hound Number 999 score 30 ...

I have a report with several subreports. The report looks like: Customer Name Contact Info* Product Info* Shipping Info* with the * being the...

I have a invoicing data base I created.I have been able to create a report that gives me the total sales broken down down by the month. I would like to to...