Form Query

[JohnM]

I am trying to set a Order Tracking database

Amongst others there are tow columns AFP (Auth for Purchase) and PO
(Purchase Order)

The AFP Column has a number but the PO Column may not be completed until a
PO has been raised

I want tm a make Form/report that only displays the Records that have a PO
Number

Whatever I do at the moment I just keep ketting all the blank records as well

thanks John

 

[Jeff Boyce]

John

Are you using a query to return the records you want to see to your form?
If not, give it a try. You can use the query's selection criterion to limit
the rows to those with [PONumber].

By the way, [AuthForPurchase] and [PurchaseOrder] seem like they could be
two of several "stages" or "steps" in a process. By storing these as
columns, you may be committing spreadsheet rather than using a relational,
well-normalized design. If you'd care to post back a bit more specific
descriptions of your fields, folks here may be able to offer more specific
suggestions...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[JohnM]

Thanks for that

Its a simple format for tracking orders
When an [AuthforPurchase] is raised the deatils are entered into the sheet
The buyers then go out for quotes, when one is selected and the PO issued
the [PoNumber] is entered onto the sheet
Included in the sheet is items such as - Approved Date, delivery date,
received date etc along with details of the item

I just need to maks database that is easy to enter data and also for viewing
certain info ie PO issued, AFPs Issued, whi AFP have beeen submitted for
approval

john

--
JohnM

John

Are you using a query to return the records you want to see to your form?
If not, give it a try. You can use the query's selection criterion to limit
the rows to those with [PONumber].

By the way, [AuthForPurchase] and [PurchaseOrder] seem like they could be
two of several "stages" or "steps" in a process. By storing these as
columns, you may be committing spreadsheet rather than using a relational,
well-normalized design. If you'd care to post back a bit more specific
descriptions of your fields, folks here may be able to offer more specific
suggestions...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I am trying to set a Order Tracking database

Amongst others there are tow columns AFP (Auth for Purchase) and PO
(Purchase Order)

The AFP Column has a number but the PO Column may not be completed until a
PO has been raised

I want tm a make Form/report that only displays the Records that have a PO
Number

Whatever I do at the moment I just keep ketting all the blank records as well

thanks John

 

[Jeff Boyce]

John

If you need easy, you can stick with Excel. Most folks can intuitively
understand a spreadsheet. ... a bit like a bookcase ... you know how to put
books on and take books off.

Most (normal) folks cannot intuitively understand "normalized". Relational
databases like Access are not simple to understand, like a bookcase. They
are power saws, used to BUILD bookcases.

"Easy" comes in because YOU have hidden all the complexity behind a very
user-friendly interface.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Thanks for that

Its a simple format for tracking orders
When an [AuthforPurchase] is raised the deatils are entered into the sheet
The buyers then go out for quotes, when one is selected and the PO issued
the [PoNumber] is entered onto the sheet
Included in the sheet is items such as - Approved Date, delivery date,
received date etc along with details of the item

I just need to maks database that is easy to enter data and also for viewing
certain info ie PO issued, AFPs Issued, whi AFP have beeen submitted for
approval

john

--
JohnM

John

Are you using a query to return the records you want to see to your form?
If not, give it a try. You can use the query's selection criterion to limit
the rows to those with [PONumber].

By the way, [AuthForPurchase] and [PurchaseOrder] seem like they could be
two of several "stages" or "steps" in a process. By storing these as
columns, you may be committing spreadsheet rather than using a relational,
well-normalized design. If you'd care to post back a bit more specific
descriptions of your fields, folks here may be able to offer more specific
suggestions...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I am trying to set a Order Tracking database

Amongst others there are tow columns AFP (Auth for Purchase) and PO
(Purchase Order)

The AFP Column has a number but the PO Column may not be completed until a
PO has been raised

I want tm a make Form/report that only displays the Records that have a PO
Number

Whatever I do at the moment I just keep ketting all the blank records

as
well

thanks John