Frustrated

  • Thread starter Thread starter Emma
  • Start date Start date
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!
 
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.
 
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"));
 
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.
 
Emma said:
Actually the query runs fine it seems to be in the report.

:

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
(e-mail address removed)

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

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

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

Hans

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
(e-mail address removed)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top