Recent content by crystalhelp

I've thought of that. Except, when I replace convert(datetime,b.dateval) >= DateADD(year,-@Years,GetDate()) and convert(datetime,b.dateval) <= getdate() with DATEDIFF(day, convert(datetime,b.dateval), getdate()) <= @Years*365) which also has the convert date statement, it doesn't give me...

The following statement works in some spots and not in others: convert(datetime,b.dateval) >= DateADD(year,-@Years,GetDate()) and convert(datetime,b.dateval) <= getdate() b.dateval is a char and @years is an int. It works when I have it in a basic where clause, but it doesn't work if I have...

PHV, didn't quite understand your question. I only have master/child field properties on my subforms, not the actual form itself. BTW, I'm in Access 97. TheAceMan1, All the fields control source properties had been changed to point to the new data source. I know they were included in the...

To create a new form, I copied and pasted from another form that was very similiar. In the new form I changed the form properties to point to the new datasource (among other changes). Now when I run and open the new form, I can't edit any of the fields. I can set focus on the fields and can...

I have a cross tab report that is rather wide and long and spans multiple pages. It exports properly to HTML and Word, but when I export to PDF the column labels, the row labels, and page numbers do not print on the pages that are too wide, but do print on the pages that are too long. Does...

Thanks!

Yeah, didn't work. Thanks anyway. If you have any other ideas, let me know. I may have to resort to sending the guy several files with each of the create table statements in their own file.

I'm using TOAD. I am hitting the green execute statement arrow. I am creating this file to pass along to someone else. I have no idea how they will execute it. I am just running it to make sure it runs cleanly. I assume if it doesn't work how I am running it, it won't work how this person...

I feel so stupid that I can't figure this out. I am writing a script that creates several tables. Essentially it starts out as: create table x( a number, b number); create table y( c number, d number); create table z( e number, f number); begin --my variable declaration -- a bunch of...

I am passing in a string to my report. It works if the string I pass in is less than 250 chars, but if it is greater, I get teh following error: 'Value does not fall within the expected range.' How do I resolve this? There is a length limit option for the parameter, which I tried setting...

I have a string that contains values seperated by commas. I want to use these values in my IN clause. This is what I mean: to simplify branch_string char(10); branch_string := '1,2,3,4'; select * from branch where branch_id in (branch_string); How can I do this? Thanks in advance.

I am using a formula to create a string. The string is long and wraps, but I would prefer to control this with line breaks. I have looked through the functions in the formula editor, but haven't found anything. Is this something I can do? Does anybody know the syntax to do this?

Evaluate for each and reset never causes the branches to total together. I want a running total, but for each branch to have it's own running total. These were my results: January Branch Count YTD Count Branch 1 4 4 Branch 2 8 12 (should be 8) Total 12 12...

I posted this on Other Topics, but maybe I should have posted this here. My report has three groupings (Year, Month, Branch). I wrote a stored procedure that successfully returns incidences to be tallied for a specified time period, plus incidences prior to the specified period, necessary for...

My report has three groupings (Year, Month, Branch). I wrote a stored procedure that successfully returns incidences to be tallied for a specified time period, plus incidences prior to the specified period, necessary for a ytd calulation. I have a branch total, monthly total, and a report...