A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Parameter variables



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 28th, 2010, 09:59 AM posted to microsoft.public.access
Jim L.[_2_]
external usenet poster
 
Posts: 56
Default Parameter variables

Part of the DB I am working on contains a table for Emergency Response
data. The primary key ([ERptNo]) is formatted as "yymmddhhmm_ _ _", the last
3 digits being the first 3 letters of the responders last name. If they were
the Incident Commander, additional information is collected & added to the IC
table, with a primary key ([ERNo]) of "yymmddhhmm". I've built a query with
fields from these tables, and need to find a way to add parameters for a
search which would open a report. I would like the IC report to show up as
the first page, then all additional responders reports on the following pages
of the report.
Some of the responder reports may be up to 30 minutes earlier or later than
the IC report time, so the primary key numbers may not match others from the
same incident, not to mention the letters from the last names.
How can I write the query parameter in the [ERptNo] field to search for the
IC primary key [ERNo] (year, month, date, hour & minute) plus or minus 30
minutes to include all responder reports, and then a wildcard to bring up all
of the different last name letters? I'm just a beginner in writing code, so
if this is possible, a detailed explanation would be appreciated.
Thank you
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.