Connecting Data (1 Viewer)

K

kloot1rr

Registered User.

Local time

Today, 02:53

Joined

Jun 10, 2015

Messages

39

• Jun 15, 2015

• #1

Hey guys - I have a query all set up and now I have to add one field from another table in it. I am looking for a date which has the criteria Now() - Last Movement Date. Last Movement Date is the column I am taking from the other table which I just added which is the ZLX02 table. When I run the query, everything but the Last Movement Date shows up. What can I do to get the Last Movement Date to show? Check out the attached pics.

 

Attachments

• 
  pic555.png

  30.7 KB · Views: 105
• 
  pic556.jpg

  98.7 KB · Views: 89
• 
  pic557.png

  42.2 KB · Views: 92

M

marlan

Registered User.

Local time

Today, 10:53

Joined

Jan 19, 2010

Messages

409

• Jun 15, 2015

• #2

Hi,

First, I'm not sour i've quite understud your question. What do you see insted of Last Movement Date?
Beside that, what date do you expect to receive from the expression Now() - Last Movement Date? result you should expected to nuber of days between these dates.

ATB

 

K

kloot1rr

Registered User.

Local time

Today, 02:53

Joined

Jun 10, 2015

Messages

39

• Jun 15, 2015

• #3

Yeah, I do want the number of days in-between these 2 dates. The Last Movement date category has no data in it at all when i run the query. I want it to show the time since it has moved in inventory, which this equation will answer. I am just wondering why nothing shows up when I run the data

Thanks for helping marlan.

 

V

vbaInet

AWF VIP

Local time

Today, 08:53

Joined

Jan 22, 2010

Messages

26,374

• Jun 15, 2015

• #4

Remove the calculation completely and see if the Last Movement field is actually showing date values.

 

K

kloot1rr

Registered User.

Local time

Today, 02:53

Joined

Jun 10, 2015

Messages

39

• Jun 15, 2015

• #5

it is not showing

 

V

vbaInet

AWF VIP

Local time

Today, 08:53

Joined

Jan 22, 2010

Messages

26,374

• Jun 15, 2015

• #6

In that case, you don't have any data in that field for those specific records. Remove the WHERE clause and you'll find that it should data for other records.