Search results

I need to get data from an excel workbook and create a table in access. The customer is keying in data from a handwritten log each morning into excel. The excel is in a template that increments the pointer to the next row after each entry. Information entered is a value recorded each hour and...

I am building a report from a crosstab query. The operator will input the begin date and end date for the report into text box on a form. A control is set on the form to click for preview report. The begin date and end dates are used as criteria for the crosstab query that the report is written...

What could cause the fields from a crosstab query not to be shown in available fields window of report wizard? I have a crosstab query that works great and list all data requested. When I try to use the report wizard to create a report from the query, none of the fields are shown in the wizards...

IS it possible to obtain the criteria for a crosstab query from a form textbox control? I am using linked tables in my database with two tables. Thank you, Wesley

I am trying to use a form to set the start date and end date for a crosstab query. The form has two unbound text boxes each named begin date and end date. The query has the following criteria " Between [Forms]![form name]![begin date] and [Forms]![form name]![end date]. I get the following error...

I am trying to set a form into the middle of screen with a size of 2.5" tall and 4" wide. The form comes up as full screen. What am I missing?

I need to get information from a database that has data in rows and display the data in columns. Columns would be Date ; Time ; Data1 ; Data2 ; Data3 ; Data4 ; ect... Data is now shown as Date ; TagIndex ; Values Rows are date; index number ; data value Example: have this now Date...