Hello, I have db and I am attempt to create a report to extract specific information from it. Im running the report from a query called followup. When I run this report it comes up blank in order to get data to appear on it I have to switch the report to design view and enter an expression which I will get to. The Fields that I have no this report are:
Followup - Date/Time which has a default value set as =DateAdd("m",3,[Order Entered])
Contact Number - Number
First - Text
Last - Text
Consultant - Text
Now in order to get all fields to show the data on the report I have to switch the report to design view and in the field that says followup on the report I have to enter =DateAdd("m",3,[Order Entered]). I dont understand why I would have to do this on the report if the default value for the [Order Entered] Field has already been set to =DateAdd("m",3,[Order Entered]). Is there something that I am not doing properly?
Followup - Date/Time which has a default value set as =DateAdd("m",3,[Order Entered])
Contact Number - Number
First - Text
Last - Text
Consultant - Text
Now in order to get all fields to show the data on the report I have to switch the report to design view and in the field that says followup on the report I have to enter =DateAdd("m",3,[Order Entered]). I dont understand why I would have to do this on the report if the default value for the [Order Entered] Field has already been set to =DateAdd("m",3,[Order Entered]). Is there something that I am not doing properly?
Comment