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?

Thanks alot. The second one was really helpful.

A REALLY did a BS job using multiple queries, but I got it to work so all is good. =-D

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...

In the same section of the report that you put the subreport, create a field that equals the value of the field in the subreport. Then make the field invisible, and a running sum over group. That way, later on in the report, you can just refer to the invisible field if you want a summed value.

Nevermind, I actually figured it out...

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?

Thanks for the reply, but thats not quite what I wanted. I dont want to specify additional conditions, I just want to set the already existing ones (meaning set the values in code rather then having the query prompt the user).

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...

May not be the best way, but you could try making a query with calculated fields then base the chart off of that.

Thanks everyone. I got it fixed. It was very similiar to what you were all saying. I had to set all variables to zero then it worked fine. Thanks again.

The footer of one of my groupings. (Not the page or report footer)

Well its only a 2 page report and the values on the first and second page are correct on the screen. But when I print, the calculated values on the first page are doubled. The ones on the second page are fine. Oh well, nevertheless, thanks for the reply.

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...