Frustrated

E

Emma

Hi I have a report for which I just created a query to select from start date
to end date. My database is acting funny now that I ask for the start and end
date, it's asking me for sex! Why is my database so screwy!
 
B

Beetle

You haven't really given us any information to work with (other than
your query is prompting you for something you didn't expect). If
you post the SQL of the query, someone may be able to offer advice
as to what might be the problem.
 
E

Emma

Here's my code:
SELECT [Tbl Client Information].[Intake Coordinator], [Tbl Client
Information].[Session Start Date], [Tbl Client Information].Status
FROM [Tbl Client Information]
WHERE ((([Tbl Client Information].[Session Start Date]) Between [Beginning
Date] And [Ending Date]) AND (([Tbl Client Information].Status)="Active"));
 
B

Beetle

Then you probably have a text box, or some other control, in
the report that is bound to a field name that doesn't exist in
the query. Perhaps at one time the record source for this report
contained a Sex field from some table and now the record source
has been changed.
 
J

James A. Fortune

Emma said:
Actually the query runs fine it seems to be in the report.

:
Click to expand...

It sounds like another programmer is messing with your report, perhaps
as the result of an April Fool's Day joke. Try restoring a backup copy
of the report, then leave a comment line in the code that tells her the
only way she'll ever get a date is by typing it in at the command
prompt! I walked through the Combat Zone during the day in Boston soon
after moving there and was asked if I wanted a date. When I asked her
to clarify the question, she gave the impression, with some amount of
cautious circumlocution, that the phrase was a euphemism for engaging in
a business transaction with a prostitute. I politely declined, noting
that I had other business that needed my immediate attention, which was
true.

James A. Fortune
[email protected]

TOM COLLINS - "A fellow-about-town whom many sought to kill for touching
them on sore points; but he always managed to vanish before his
destroyers as he was imaginary." (2) A mythical being to whom rumours
and reports of doubtful authenticity were attributed, especially in the
Riverina. -- Dictionary of Australian Slang, Second Edition, Sidney J.
Baker, 1943 (Price: Three shillings & sixpence)
 
H

Hans Up

James said:
I walked through the Combat Zone during the day in Boston soon
after moving there and was asked if I wanted a date. When I asked her
to clarify the question, she gave the impression, with some amount of
cautious circumlocution, that the phrase was a euphemism for engaging in
a business transaction with a prostitute.
Click to expand...

Wow! I learn so much reading this newsgroup. I never knew Boston
hookers practice cautious circumlocution! :)

Hans
 
J

James A. Fortune

Hans said:
Wow! I learn so much reading this newsgroup. I never knew Boston
hookers practice cautious circumlocution! :)

Hans
Click to expand...

My suspicion is that her circumlocutory response was an effort to
safeguard against the possibility of giving an undercover :) officer
probable cause.

James A. Fortune
[email protected]

PUSH UP FOR - To approach. An underworld term used to describe a
careful approach to a victim. Whence, "pushing up" : such tactics. --
Dictionary of Australian Slang, Second Edition, Sidney J. Baker, 1943
(Price: Three shillings & sixpence)
 
B

Bill Mosca

I'm told lots of males ask for sex after the StartDate. that usually results
in an EndDate.

I'm guessing it's a field in the report's sorting and grouping and it
expects to find that field in the query.
 
E

Emma

Hi Bill,

Actually the sex was in an expression in the group and sort. I managed to
get rid of it and only keep the dates. Thanks
 
Top