Results 1 to 2 of 2
  1. 08-23-2011, 05:45 PM #1
    Asif Sayed
    Asif Sayed is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    1

    Access Query

    I have two tables "Booking" & "Rent"



    Based on date of booking and type of tenant rent for the property is to be decided.

    if you want i can send you the access file through email
    Reply With Quote Reply With Quote
  2. 08-23-2011, 06:07 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,921
    Would have to know your data structure to advise. Attach file to post, run Compact & Repair, zip if still large.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Rewriting SQL Server Query to Access query not without problems
    By Axeia in forum Queries
    Replies: 12
    Last Post: 05-22-2011, 03:49 PM
  2. Convert Access query to SQL Server query
    By mkallover in forum Queries
    Replies: 2
    Last Post: 05-13-2011, 06:20 AM
  3. Access error: 'Query input must contain at least one table or query'
    By johnmerlino in forum Access
    Replies: 10
    Last Post: 02-02-2011, 05:48 PM
  4. Help with Access Query
    By dae2604 in forum Access
    Replies: 2
    Last Post: 10-21-2010, 07:23 AM
  5. Sql server query to MS access query
    By blazixinfo@yahoo.com in forum Queries
    Replies: 0
    Last Post: 07-07-2009, 08:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums