PC Review


Reply
Thread Tools Rate Thread

how do I resolve a conflict with Unmatched records

 
 
Pitlochry1
Guest
Posts: n/a
 
      23rd Feb 2009
I have created a query for every calendar month that finds unmatched records
for expected receipts, and another query for every calendar month that finds
unmatched records for unexpected receipts. To open up the report to non
Access programmers I placed a date parameter, however this only works when it
is in the primary query when finding the unmatched records. Is there any way
of resolving the other way? it comes up asking for parameters that are not
there!
Or is there a simpler way of getting the same results? It does work with
query searching for 'last months' receipts, but not when changed to a date
parameter

 
Reply With Quote
 
 
 
 
KARL DEWEY
Guest
Posts: n/a
 
      23rd Feb 2009
Post the SQL of your query.
--
KARL DEWEY
Build a little - Test a little


"Pitlochry1" wrote:

> I have created a query for every calendar month that finds unmatched records
> for expected receipts, and another query for every calendar month that finds
> unmatched records for unexpected receipts. To open up the report to non
> Access programmers I placed a date parameter, however this only works when it
> is in the primary query when finding the unmatched records. Is there any way
> of resolving the other way? it comes up asking for parameters that are not
> there!
> Or is there a simpler way of getting the same results? It does work with
> query searching for 'last months' receipts, but not when changed to a date
> parameter
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to resolve a parameter conflict with unmatched records query? Pitlochry1 Microsoft Access Queries 7 24th Feb 2009 09:09 AM
why some files on remote showing unmatched,conflict and unchanged =?Utf-8?B?UHJhYmhhdCBTYXVyYXY=?= Microsoft Frontpage 1 13th Nov 2006 10:30 AM
why some files on remote showing unmatched,conflict and unchanged =?Utf-8?B?UHJhYmhhdCBTYXVyYXY=?= Microsoft Frontpage 0 13th Nov 2006 07:47 AM
resolve unmatched files in Frontpage =?Utf-8?B?Q2hyaXN0aWFu?= Microsoft Frontpage 14 9th Nov 2006 03:57 AM
File in Conflict-- Unmatched? Michael Microsoft Frontpage 2 28th Oct 2004 10:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:35 PM.