Web Development

Ask something
Question Locked

Req_del_date Field

0 helpful
5 replies

by jmcghee

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am needing help. I have a form that pulls form that pulls from a query and I can get it to pull the data that I enter into my field. This date is entered on a form we use for PO's and we have multiple line items but the date just repeats the same value on all items. Are they a way possible to be able to enter one date on one item line then another date on another item line. I hope this makes since.

Thanks,
Jason

5 replies

by robo_dev

First of all, is this .net, VB, or what database and language?

Most queries do what they are told, so to fix your problem, you would need to post your query and a basic description of your form (is this an input form or a form to build a query for output?

Devshed is a good forum for programmers:
http://forums.devshed.com/

by jmcghee

The form is an input. The users enter the data and then I have it setup when you press the print po button that it populates the report. Here is a copy of my query: SELECT tbl_PO_Header.PO_Num, tbl_PO_Header.Vendor, tbl_PO_Header.closed, tbl_PO_Header.closed, tbl_PO_Header.Req_del_date
FROM tbl_PO_Header
WHERE (((tbl_PO_Header.closed)=No) AND ((tbl_PO_Header.Date_Approved_Corp) Is Not Null));

The main language is a mix of VB and VBA to answer that question for you. I have tried to create additional date fields to have populate the different dates but they all pull the same value and do not change. With this information provide do you have any solutions?

Thank You,
Jason

by thumbsup2

... why do you have tbl_PO_Header.closed listed twice in the select statement?

by robo_dev

So the first question would be if the query works right all by itself.

Is the result that the req_delete_date on the report is not the correct value?

Are they all the same as the first item retrieved, or some other value?

This discussion is closed to new replies.