Replies

A little bit of knowledge is a dangerous thing.

Oops.

Thanks both.

right, this is not a secured database.

i am assuming this was his shortcut method of security; I am searching for the transparent command button that will reenable the bypass key.

no, there is no phone; unless anyone knows Paul Doheny. they were going to move him to a cubicle from an office; he called in with family problems; needed a week; called in after a week and needed rwo more weeks; and they never saw him again. They think he did not want to move into the cubicle.

thanks all for the ideas.

Query is timing out.

Change this?

On your tools toolbar there is abutton for drawing lines, just like on the draw toolbar in Word.

Click on.

Place cursor, drag out length of line in report design view.

ditto.

Thanks a ton for the 411. Still not good with calling functions; somehow I manage to not get it; but this should help me cut my teeth. thnxagin

Thanks for the great instruct. Now getting to know my date Serial function. thnxagin

Thanks Mark

I understand the SQL; thanks for the detail.

I cheated, in the QBE multiplied year by 100 and added month added as row value in ctab so there is something in the query I do not want,
plus used column headings.

The SQL is what you posted.

Thanks a million.

IN queries you need to look at the View/Totals option

In Reports you need to look at the sorting and grouping options as well as section headers.

Also, in reports, look into the iif function in conjunction with sum i.e., sum(iif([fieldname])=criteria,1,0))

HTH.

Set source of combobox to

[query]![queryname]![fieldname]

Search MSKB for filter by form

In the Mail Merge dialog box the 2nd option, Get Data drop down list, select Open Data Source (Not Create Data Source) and pick data2002.

Jennfier,

If you are using v. 10 of SPSS ODBC (Open Data Source), you must establish a login/password for each data file. This “feature/bug” is documeted on spss.com Answer Net. Login/password has to be established for each Access file.

The XL to get to SPSS option will also work though you will want to use an XL format prior to 97/2000 or wk1 or dbf.

If this a task that is to be repeated and you cannot figure out the ODBC login paswword feature, you can create macro to export Access data to comma delimited file and use SPSS Data List syntax command to bring in data and assign variable names and SPSS data formats. This option gets around numerous conversion isssues and can be automated with some advanced techniques (i.e., shell command to execute SPSS and SPSS production facility).

HTH

OK, base report on table or a query.

In details section of report just place controls all on same level.

event date1 date2

This will display all info in table.

Key is placing controls in report at same horizontal level.

Post your criteria. It should be like:

Between #1/1/02# and #1/31/02#

Store all dates in the one column. There is no reason for a third February date column if I understand you correctly and that is what you are doing.