RE: report with queries problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

You are correct, for some reason this is how when I enter it in the criteria
it ends up in the title column but the query works fine... but it would be
the RNLTD Column that has the date Report No LAter Than...

"KARL DEWEY" wrote:

WHERE (((Input_Gain.Title) Between Int(Date()) And Int([RNLTD])));
Does your field Input_Gain.Title contain a date? It seems to me that it
would have text.
--
KARL DEWEY
Build a little - Test a little


"JeremyReger" wrote:

Success!

The Appointment one works to query what is up for that day, but what about
the Incoming Personnel Query where you want it between two dates?

Thank you again!

"KARL DEWEY" wrote:

Try using ---
HAVING Int(Input_Appointment.Date)=Date();

--
KARL DEWEY
Build a little - Test a little


"JeremyReger" wrote:

I apologize... I had an idiot moment.... I will just use the "sub report"
feature... if I can ever get the sub report to show up... but FYI... Here was
my Query SQL:

For My Appointment Query

SELECT Input_Appointment.FirstName, Input_Appointment.LastName,
Input_Appointment.Rank, Input_Appointment.Appointment_Type,
Input_Appointment.Time, Input_Appointment.Date
FROM Input_Appointment
GROUP BY Input_Appointment.FirstName, Input_Appointment.LastName,
Input_Appointment.Rank, Input_Appointment.Appointment_Type,
Input_Appointment.Time, Input_Appointment.Date
HAVING (((Input_Appointment.Date)=Date()));


For my Incoming Personnel Query

SELECT Input_Gain.Title, Input_Gain.FirstName, Input_Gain.LastName,
Input_Gain.Type, Input_Gain.Location, Input_Gain.RNLTD
FROM Input_Gain
WHERE (((Input_Gain.Title) Between Int(Date()) And Int([RNLTD])));




"KARL DEWEY" wrote:

But any of the queries that come with the "input.appointment.whatever" do
not work, but I what the problem is...
Post the query SQL for the above.
--
KARL DEWEY
Build a little - Test a little


"JeremyReger" wrote:

I created a database to enter in personnel and their status such as who is on
vacation, who is working in another office, and who has appointments for the
day. I went through and created queries for each table such as appointments,
vacation, etc... When I go to add them to my report some go in as:

input.appointment.Name
input.appointment.Title
Date
Time

And the only ones that go on the report correctly are the ones that all come
onto the report as:

Name
Title
Date
Time

But any of the queries that come with the "input.appointment.whatever" do
not work, but I what the problem is...

Thank you for your help!!!
.

Relevant Pages

  • RE: Trouble passing query criteria using VBA
    ... "KARL DEWEY" wrote: ... The query would use the textboxes for criteria. ... Is it even possible in Access 2003 to call a report using VBA and pass it ...
    (microsoft.public.access.macros)
  • RE: Count and Filter Result
    ... "Sonya" wrote: ... "KARL DEWEY" wrote: ... Run the counting query alone to check there. ... You did not join [Minor Disciplinary Report] and [Minor Disciplinary Report ...
    (microsoft.public.access.reports)
  • RE: Trouble passing query criteria using VBA
    ... The query would use the textboxes for criteria. ... Is it even possible in Access 2003 to call a report using VBA and pass it ... "KARL DEWEY" wrote: ...
    (microsoft.public.access.macros)
  • Re: Sorting and Grouping not working
    ... "KARL DEWEY" wrote: ... When you run the query you show by itself, ... then it returns ungrouped data. ... If I remove the grouping here and rely on the report to sort/group, ...
    (microsoft.public.access.reports)
  • RE: Recognizing comma separators in reports
    ... Open the query in design view, ... items with multiple entries (the ones with the comma separators). ... "KARL DEWEY" wrote: ... gotten my half way toward my goal - the report recognizes the commas, ...
    (microsoft.public.access.reports)