473,408 Members | 2,888 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

How to use User query Input to output to a report lable

Hello and thanks ahead of time. I'm using a Query of dates with the following Criteria "Between [Date] and [Date2]". Now what I'm trying to figure out is how to translate Date1 and Date2 to a report for a title, Example being "Report between: Date1 and Date2". Thanks again.
Jul 15 '14 #1
1 858
twinnyfo
3,653 Expert Mod 2GB
One possible way to do it would be to have the Dates the user inputs be actual field names in your Query:

Expand|Select|Wrap|Line Numbers
  1. [Date1] AS StartDate, [Date2] AS EndDate
Then you can use those fields in your report.

I am sure there are other ways to do it.
Jul 15 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: jpatterson | last post by:
Hi, I need to be pointed in the right direction. I'm looking for a way to dynamically change a table in a query. I have a table called students and each fiscal year the student table will get...
2
by: Galina | last post by:
Hello All of a sudden I started getting error 13, type mismatch in a command, which was running happily for years. Here is a code: Option Compare Database Option Explicit Dim CmdClose1_Clicked...
2
by: Tom | last post by:
Hi all: I've run into a problem that is confounding me. Hope you can help. I have the following query (having removed alot of stuff for clarity: SELECT tblComponent.TagNumber,...
4
by: Jerry LeVan | last post by:
Hi, I am adding image and large object support in my Cocoa postgresql browser. Are there going to be any enhanced bytea support functions coming along? It seems sorta silly to have to write...
24
by: djsdaddy | last post by:
Good Day to All, This is my first post to the scripts, and I'm glad to be part of a community of experts that can pull me out of the holes that I sometimes dig for myself. I am running XP and Access...
3
by: John Williams | last post by:
I'm writing a stagenography program to experiment with how it works. The algorithm I'm using appears to be producing the correct result...however I'm struggling with the file input. I never...
1
by: shihan02 | last post by:
Hello. I am new to MS Access and am trying to set up a simple data base for my martial arts company. I have only one table (a listing of student information) and seem to be okay at setting up...
6
by: Mmmel | last post by:
HELP! I'm about to have a total meltdown! I've been trying all sorts of things to do the following. I have a financial database that contains incomes and expenses. I have it set up so that each...
2
sueb
by: sueb | last post by:
I have a crosstab query that gathers all records for a fiscal year specified by the user's input, then counts the number of records that fall within a specific month, grouped by a discriminant in...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.