Hello All I need some help:
I have a small DB in access that has data entered via text boxes on a form. It is for confirming orders and such. There are five sets of entry boxes simply listed as Size, Qty, Num(not same as qty), Size II, Qty II, Num II, Size III you get the idea. Only the first set is required to be entered, and the remaing ones can be left blank (at least one or two will be 99% of the time). The text boxes all update to the Table properly. When I run a query it displays everything including the fields that have no data, which in turn means the reports I need to run have blank lines in them. How do I suppress the fields that have no data entered so they don't show on the report leaving a bunch of unwanted and unnecessary white space? I have tried IsNull in the criteria of the fields through the query, but that seems to eliminate all records except ones that have info in the four sets of unreqiured text boxes(not all records have more than one set of data entered due to order size). I hope this makes sense. If there is not a way to do this (I feel there is) could a work around like setting a default value for each of the unrequired boxes be put in and then set th query/report to output where (field) not = XXXX? Thanks in advance for your help.
4 1616
Anyone got any ideas on this?
Old Bird thanks for the respose
Simple customer info like biz name, phone #, address, distributor is in the table with most info simply being text. The primary key is an autonumber generated by Access because there are multiple instances of the same customer due to repeat orders (thankfully). It has been working fine with only set of inputs but when a I needed add couple of fields (check box and a another textbox), so I figured add add the capability of adding mulitple products with out having to go to a new record and re-enter all the customer data. As I said the form puts the info inside the table correctly I just can seem to figure out how to get it back out in a report the way I'd like.
You don't mention normalization. Did you attempt to read the link?
You should have a customer table, with
Simple customer info like biz name, phone #, address, distributor
and an order table with
Size, Qty, Num(not same as qty)
Your reports would be based on a query joining the 2 tables. Where repeat orders not 5, then orders table would have the correct number of rows, even 6+ thankfully.
I believe planning should preceed design, and I think if you go the direction you have started, you will never get your project working correctly.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Anon |
last post by:
Hi, to not deceive you this is a school project. We are developing some XSLT
to format some data in HTML for Internet Explorer. The work uses XSLT and
CSS and XML. The objective is to write a...
|
by: AMDRIT |
last post by:
The stuff below seems to work, when I am applying the logic for suppression.
However, it doesn't work when suppressing row data. Any Ideas?
Basically, if there is only one row of data, I need to...
|
by: Stanley |
last post by:
Process p = new Process();
p.StartInfo.FileName = "a.exe";
//...........
when it executes, it may be create segment error, and the
error will be displyed on the screen.
how can I make it...
|
by: James Radke |
last post by:
Hello,
I have a multithreaded windows NT service application (vb.net 2003) that I
am working on (my first one), which reads a message queue and creates
multiple threads to perform the processing...
|
by: Peter Ritchie |
last post by:
Does anyone know how to suppress a specific warning for a line or block of
code in C#? C++ has a nice facility to disable a warning for a block of code
with #pragma for warnings that are incorrect...
| |
by: Ryker |
last post by:
I have a Purchase Order where I have a calculated field called Price
that is calculated by multiplying Qty * Sales Price. I have 10 of
these fields...Price 1 - Price 10 (for each line of the PO). ...
|
by: monomaniac21 |
last post by:
Hi all!
How can you get rid of the error that displays if you do a query which
returns no result and then try and fetch the array, WITHOUT having to
put the while in another conditional like if...
|
by: Max TenEyck Woodbury |
last post by:
I need a macro that will take an arbitrarily long list of arguments
where each argument needs to be passed to another macro.
Is it possible to write such a macro?
If so, could you please...
|
by: Hugh Middity2 |
last post by:
Hello,
We have a report printing numeric fields. Is it possible to suppress the field if the value is zero? Thanks
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |