I am not even sure how to explain this, but I will try.
At the end of each week I have to send to each individual customer, a list of all the requisitions that they ordered for the entire week. This list provides the customer with Req. #, Material ID info, Quantity, and the latest status...
Is there a way to display the information that the user has to enter to get results from a query onto a form or report?
Huh?!?! I mean, say I have a query that asks you to type in a date ('Between [Date] and [Date]'). Is there a way to have those entries displayed on the form or report that...
Alright, I have ten different queries. Here is the SQL for one of them.
SELECT [DCU LOG].[Doc#], [DCU LOG].JCN, [DCU LOG].[PART NO], [DCU LOG].SERNO, [DCU LOG].[JD T/I], [DCU LOG].MCN, [DCU LOG].PC, [DCU LOG].STATUS, [DCU LOG].REMARKS, *
FROM [DCU LOG]
WHERE ((([DCU LOG].[JD T/I]) Between...
I have a form that is used to edit and print out records. To print a record, you have tag a check box so that when you print, it will only print the records that are tagged. If two people are using it, then it will print the records that both people have selected. How can I set it up that both...
We use a Julian Date for just about everything where I work. How can I format the date for this? For example, a Julian date for March 16th, 2001 would look like: 01075.
01 being the year.
075 being the day of the year.
I feel a little stupid with this one, but I have tried just about everything I know (which isn't much), and I cannot get this to work the way I want it to. I have a form:
1348-1 which is based on a query: Q-1348-1. The query is getting information from three different tables: DCU Log, ICRL-1...
On my form, I have several fields that are updated automatically with fields from two other tables by using Dlookup in the control source of the fields in the form. The problem is, when a null value is returned to these fields, I need to be able to manually input the information, but I can't do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.