Newbie question

[Guest]

i have a DB of lines of prodocts produced, i have on my table: date, line,
pounds, # of workers, ect.. i finanally made a form to input this data and
can print a rport of this data. now i need a way to make a report of this
data with another form that pops up and asks for date AND/OR line number and
pulls a report based on that data. (line number refers to the actually
packing line) I've looked everywhere and everyone is doing soemthing more
advanced than this. also i need the report to do some calculations (net
pounds, gross pounds, lbs per worker, ect) and dont know how to evn began
that. If anyone cal help with soem links on the basics of these subjects that
would be very helpfull. Thanks in advance.

 

[Guest]

Create a query and in design view select your table. Select all of the
fields by double clicking each one in the table.

In the row labeled Criteria and column of YourDate field enter the following –
[Enter date – m/d/yy]
In the same row labeled Criteria and column of YourLine field enter the
following –
Like [Enter line number] & “*â€

In the above you must enter a date but only have to enter a partial line
number.

Create your report based on this query.


:

I have a DB of lines of products produced, I have on my table: date, line,
pounds, # of workers, etc.
I finally made a form to input this data and can print a report of this data.
Now I need a way to make a report of this data with another form that pops
up and asks for date AND/OR line number and pulls a report based on that data
(line number refers to the actually packing line).
I've looked everywhere and everyone is doing something more advanced than
this.
Also I need the report to do some calculations (net pounds, gross pounds,
lbs per worker, etc) and don’t know how to even began that.
If anyone cal help with some links on the basics of these subjects that
would be very helpful.
Thanks in advance.

 

[Guest]

Thanks Karl that worked pretty well except I need a way where the user can
enter only the line number and pull up all info from that line number or be
able to put in a date range, can you help me with that.

 

[Guest]

Use one query with the date criteria to pull by date.

Use a different query with the Line number criteria just to pull by line
number.

Thanks Karl that worked pretty well except I need a way where the user can
enter only the line number and pull up all info from that line number or be
able to put in a date range, can you help me with that.

Create a query and in design view select your table. Select all of the
fields by double clicking each one in the table.

In the row labeled Criteria and column of YourDate field enter the following –
[Enter date – m/d/yy]
In the same row labeled Criteria and column of YourLine field enter the
following –
Like [Enter line number] & “*â€

In the above you must enter a date but only have to enter a partial line
number.

Create your report based on this query.


:

I have a DB of lines of products produced, I have on my table: date, line,
pounds, # of workers, etc.
I finally made a form to input this data and can print a report of this data.
Now I need a way to make a report of this data with another form that pops
up and asks for date AND/OR line number and pulls a report based on that data
(line number refers to the actually packing line).
I've looked everywhere and everyone is doing something more advanced than
this.
Also I need the report to do some calculations (net pounds, gross pounds,
lbs per worker, etc) and don’t know how to even began that.
If anyone cal help with some links on the basics of these subjects that
would be very helpful.
Thanks in advance.

 

[Guest]

OK i found a way to make a form pull from a query this information now the
problem is i need to pull this same information into a report, when i run a
report from that query it pulls up the "enter paramter value" which dosnent
look good to a user. Is there anyway i can have a rpeort pull up the form
Ive created first? or is there a better way to do this all around.

Use one query with the date criteria to pull by date.

Use a different query with the Line number criteria just to pull by line
number.

Thanks Karl that worked pretty well except I need a way where the user can
enter only the line number and pull up all info from that line number or be
able to put in a date range, can you help me with that.

Create a query and in design view select your table. Select all of the
fields by double clicking each one in the table.

In the row labeled Criteria and column of YourDate field enter the following –
[Enter date – m/d/yy]
In the same row labeled Criteria and column of YourLine field enter the
following –
Like [Enter line number] & “*â€

In the above you must enter a date but only have to enter a partial line
number.

Create your report based on this query.


:

I have a DB of lines of products produced, I have on my table: date, line,
pounds, # of workers, etc.
I finally made a form to input this data and can print a report of this data.
Now I need a way to make a report of this data with another form that pops
up and asks for date AND/OR line number and pulls a report based on that data
(line number refers to the actually packing line).
I've looked everywhere and everyone is doing something more advanced than
this.
Also I need the report to do some calculations (net pounds, gross pounds,
lbs per worker, etc) and don’t know how to even began that.
If anyone cal help with some links on the basics of these subjects that
would be very helpful.
Thanks in advance.

 

[Guest]

You can put a command button on the form to run a report.

You can write code for an EVENT or write a macro. Either one can use the
data pulled with the query and not prompt a second time.

OK i found a way to make a form pull from a query this information now the
problem is i need to pull this same information into a report, when i run a
report from that query it pulls up the "enter paramter value" which dosnent
look good to a user. Is there anyway i can have a rpeort pull up the form
Ive created first? or is there a better way to do this all around.

Use one query with the date criteria to pull by date.

Use a different query with the Line number criteria just to pull by line
number.

Thanks Karl that worked pretty well except I need a way where the user can
enter only the line number and pull up all info from that line number or be
able to put in a date range, can you help me with that.

:

Create a query and in design view select your table. Select all of the
fields by double clicking each one in the table.

In the row labeled Criteria and column of YourDate field enter the following –
[Enter date – m/d/yy]
In the same row labeled Criteria and column of YourLine field enter the
following –
Like [Enter line number] & “*â€

In the above you must enter a date but only have to enter a partial line
number.

Create your report based on this query.


:

I have a DB of lines of products produced, I have on my table: date, line,
pounds, # of workers, etc.
I finally made a form to input this data and can print a report of this data.
Now I need a way to make a report of this data with another form that pops
up and asks for date AND/OR line number and pulls a report based on that data
(line number refers to the actually packing line).
I've looked everywhere and everyone is doing something more advanced than
this.
Also I need the report to do some calculations (net pounds, gross pounds,
lbs per worker, etc) and don’t know how to even began that.
If anyone cal help with some links on the basics of these subjects that
would be very helpful.
Thanks in advance.

 

[Guest]

Can i have a link or somehting to help me with this code.. i tried adding
code to the "on open" propority on the report but that pulled up the report
and then the form. also does anyon ehave a good totaling fields on a report
FAQ .

You can put a command button on the form to run a report.

You can write code for an EVENT or write a macro. Either one can use the
data pulled with the query and not prompt a second time.

OK i found a way to make a form pull from a query this information now the
problem is i need to pull this same information into a report, when i run a
report from that query it pulls up the "enter paramter value" which dosnent
look good to a user. Is there anyway i can have a rpeort pull up the form
Ive created first? or is there a better way to do this all around.

Use one query with the date criteria to pull by date.

Use a different query with the Line number criteria just to pull by line
number.

:

Thanks Karl that worked pretty well except I need a way where the user can
enter only the line number and pull up all info from that line number or be
able to put in a date range, can you help me with that.

:

Create a query and in design view select your table. Select all of the
fields by double clicking each one in the table.

In the row labeled Criteria and column of YourDate field enter the following –
[Enter date – m/d/yy]
In the same row labeled Criteria and column of YourLine field enter the
following –
Like [Enter line number] & “*â€

In the above you must enter a date but only have to enter a partial line
number.

Create your report based on this query.


:

I have a DB of lines of products produced, I have on my table: date, line,
pounds, # of workers, etc.
I finally made a form to input this data and can print a report of this data.
Now I need a way to make a report of this data with another form that pops
up and asks for date AND/OR line number and pulls a report based on that data
(line number refers to the actually packing line).
I've looked everywhere and everyone is doing something more advanced than
this.
Also I need the report to do some calculations (net pounds, gross pounds,
lbs per worker, etc) and don’t know how to even began that.
If anyone cal help with some links on the basics of these subjects that
would be very helpful.
Thanks in advance.