Search results

I have a column called Name that is a string. I need a query that will select all records that begin with any non-alphabetical character (basically, any record that doesn't start with A-Z). Example: #sample 3sample joe sally ~!sample Should Return: #sample 3sample ~!sample The query will...

I have a form that opens up with 3 different combo boxes. Each combo box is populated by a different column from a table. The user selects a value for each of the three combo boxes, then clicks a button. What this does is opens a query that checks the value of each combo boxes and filters the...

This should be easy, I guess I'm just missing the obvious. I have a combo box that is populated by a query. I want to have it so the user can click on the dropdown and select whatever they want, but they cant type into the combo box. What am I missing?

Ok, this is fairly complex so I'll try to be specific as possible. Here is what I currently have. SELECT [C_TS1].[Year-Month], [C_TS1].Classification, [C_TS1].[SumOfActual], Sum([C_TS1_1].[SumOfActual]) AS ActualRunSum, [C_TS1].[SumOfBudget], Sum([C_TS1_1].[SumOfBudget]) AS BudgetRunSum...

First off, charts, specially in Access 97, are evil... but enough of my rant. I have a report that displays a chart. When you open the report, it prompts you for a date (as it should). For some reason, when I try to print the chart, it requires me to enter the date again. If I do, all works...

I have a subreport in the detail section of one of my reports. On the footer of the main report, I want to sum up the value of a column in the subreport. I've been fighting with this thing for some time to no avail. Any suggestions?

I have a query that prompts a user for input. However, in some reports I have that use the query, I'd rather just set the value instead of prompting for it (while others I need the prompt). Is there a way to do this without creating a new query? Basically, is there a way in VBA to pass an...

When I view my report in Access, everything is fine. However, when I print the report, it prints different numbers then were displayed on the report on the screen. What's going on here? A few notes, I have a report and subreport. The subreport prints fine, but the reports numbers change. Only...

Here's my issue. I wrote VBA code that does a couple calculations for me. It works fine (I should mention this is in a form). The form is based off a query. The query asks for the user to input a date. If the date returns any results, everything works fine. However, if the date returns no...

I have two unrelated tables that have an equal number of records. I need a query that will just show the columns of the first next to the columns of the second. Example: Table A 1 2 3 1 2 3 Table B 4 5 6 4 5 6 RESULT 1 2 3 4 5 6 1 2 3 4 5 6 [This message has been edited by Dominato (edited...