Page 2 of 4 FirstFirst 1234 LastLast
Results 16 to 30 of 51
  1. 04-09-2017, 05:40 AM #16
    dtoxic's Avatar
    dtoxic
    dtoxic is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    31
    Someone Please Help me with this.
    Reply With Quote Reply With Quote
  2. 04-09-2017, 05:47 AM #17
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Yep got it. Now the table structure. Have you got it


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  3. 04-09-2017, 06:02 AM #18
    dtoxic's Avatar
    dtoxic
    dtoxic is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    31
    Quote Originally Posted by andy49 View Post
    Yep got it. Now the table structure. Have you got it
    Yes, you Sent me this Structure bro.

    tblReadings:
    ReadingID (Auto)
    PumpID (FK) (int)
    Reading (long)
    Reading Date/Time (Date/Time)

    tblPupms
    PumpID (Auto)
    PumpName (Text)
    PumpFuel (FK)

    tblFuel
    FuelID (Auto)
    FuelType (Text)
    UnitPrice (Decimle)
    Reply With Quote Reply With Quote
  4. 04-09-2017, 06:04 AM #19
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Relationships next?


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  5. 04-09-2017, 06:05 AM #20
    dtoxic's Avatar
    dtoxic
    dtoxic is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    31
    Yeah, Relationships
    Reply With Quote Reply With Quote
  6. 04-09-2017, 06:12 AM #21
    dtoxic's Avatar
    dtoxic
    dtoxic is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    31
    Where to take this Foreign Key from?

    tblPumps
    PumpID (Auto)
    PumpName (Text)
    PumpFuel (FK)
    Reply With Quote Reply With Quote
  7. 04-09-2017, 06:14 AM #22
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Fuelid


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  8. 04-09-2017, 06:29 AM #23
    dtoxic's Avatar
    dtoxic
    dtoxic is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    31
    Relationships Done. Now Working on Queries. I will Definitely let you know if something goes wrong.
    Reply With Quote Reply With Quote
  9. 04-09-2017, 07:14 AM #24
    dtoxic's Avatar
    dtoxic
    dtoxic is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    31
    Here is the Query, is this Correct?
    Click image for larger version.  Name: Query.PNG  Views: 8  Size: 22.6 KB  ID: 28197
    Reply With Quote Reply With Quote
  10. 04-09-2017, 07:27 AM #25
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    What is this for? A form where people input info?


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  11. 04-09-2017, 07:36 AM #26
    dtoxic's Avatar
    dtoxic
    dtoxic is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    31
    Exactly.. There is only One user who is going to Input Data and Make Reports for Each Day's Sales.
    Reply With Quote Reply With Quote
  12. 04-09-2017, 07:48 AM #27
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Can you zip your current file and post it on here dtoxic I need a closer look


    Sent from my iPhone using Tapatalk
    Reply With Quote Reply With Quote
  13. 04-09-2017, 09:06 AM #28
    dtoxic's Avatar
    dtoxic
    dtoxic is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    31
    Check Private andy49
    Reply With Quote Reply With Quote
  14. 04-09-2017, 11:57 AM #29
    dtoxic's Avatar
    dtoxic
    dtoxic is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    31
    DB.zip

    Here is my File Bro
    Reply With Quote Reply With Quote
  15. 04-09-2017, 12:50 PM #30
    andy49's Avatar
    andy49
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051

    have a look at form 2 and try and enter a few current readings. see what you think

    Test 3.zip



    have a look at this.
    Reply With Quote Reply With Quote
Page 2 of 4 FirstFirst 1234 LastLast
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Missing 3000 records - when transferred from 2007 access to 2016 access -- same data backup - help
    By Bonnie in forum Access
    Replies: 2
    Last Post: 11-02-2016, 11:41 AM
  2. problem with calculated fields in Access 2016
    By Elfi in forum Access
    Replies: 4
    Last Post: 03-01-2016, 12:04 PM
  3. Have Access warn or veto when incompatible values are entered in a pair of fields
    By E. Rumsey in forum Forms
    Replies: 3
    Last Post: 11-08-2012, 10:38 AM
  4. Access: Updating Null Fields with values
    By bmaz in forum Queries
    Replies: 2
    Last Post: 10-11-2011, 05:18 PM
  5. Convert table/query values to fields in a single record in Access 07
    By bcmarshall in forum Access
    Replies: 7
    Last Post: 11-13-2010, 08:08 AM

Tags for this Thread

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