Parameter Query CrossTab - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Parameter Query CrossTab

Jeffrey Norment

3 years ago

Trying to force Access to create a report similar to an Excel spreadsht currently used (image attached). The closest I have come is using a crosstab query (image attached). The crosstab is based on a query that uses pay period end date as a parameter prompt. In the crosstab the parameter is defined. The crosstab query is used to create a report. When the report is opened it prompts the user 2x for the date. Once is ok, >1 is a nonstarter. Suggestions?

	Jeffrey Norment OP @Reply 3 years ago

	Jeffrey Norment OP @Reply 3 years ago

	John Davy @Reply 3 years ago
Hi Jeffrey Without seeing the query I am only guessing. If you have a second table in your query check the link to see if might cause the input to be requested twice. John

	Jeffrey Norment OP @Reply 3 years ago

	Jeffrey Norment OP @Reply 3 years ago
qryTimeSheetData has the parameter statement. qryTimeShtCrossTab query is based on qryTimeSheetData and declares the the parameter used in qryTimeSheetData. I created a report using qryTimeShtCrossTab, but the parameter request occurs twice when the report opens.

	Jeffrey Norment OP @Reply 3 years ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View