Search results

I am creating a percent line in my code in an effort to summarize data in a report. I'm quite rusty on my VB, and I just can't remember how to limit the length of numbers my code is as follows: lblPerct.Caption = Str((lblSending.Caption / lblTotal.Caption) * 100) & "%" the code works...

chicken pot pies.

Never-the-less he continued

is there some way of creating a format for the exported table? It's a report that's getting created on a weekly basis, and going through and formatting it each time is not really an effective way of doing it.

Maybe this attachment helps more.

My report is effectively a spreadsheet. the only problem is that I cannot compress the output to fit onto a single page like the old spreadsheet used to be able to. I've changed and played with most settings in the property sheet, but to no avail. The attached picture is at good as it has...

thank you. I feel like an idiot... I deserve to.

Access 2007 I am trying to set up a conditional formatting on the cells in a report, but I can't seem to get it right, I searched but didn't find anything applicable. I'm having issues with turning a certain text value yellow. The fields have 4 specific outputs. Empty (null), any possitive...

This worked, but to follow up, by doing it with the WHERE function, I wont be able to do the count on multiple columns without creating multiple queries, correct? (i.e. counting wk1 and wk2 ... wk9) So I will need to create 9 different queries to count the individual weeks... Or is there another...

I am having issues with creating a counting function that counts only fields that meet the > 0 criteria. The columns consist of only numerical data and some null values. What do I need to change for the count function to work with my criteria? This is the SQL provided by the query. I can see...

here is a picture of my table (unpopulated still in testing). My goal is to run a query to make all the blanks say "0". Should I rethink the query using "IS NULL" criteria, or restart and try something else?

I have a set of queries that dump into a table, but a recent change has them leaving blanks (instead of 0's). I'm trying to create an update query that will sort through the numbers (and blanks) and place a 0 (zero) in the columns that currently have no contents. I'm experimenting with an update...

I give up, Unless there is a solution, I'm oging to do this the sloppy way and just make 9 amend table queries then query the table, since nothing I have tried is looking like it is working

i've made a little progress since posting it, but nothing substancial. I have 9 queries that sumarize 1 week each for number of entries sqyWeek(1-9)Count: ShipName CountOfID (not being used) SumOfReceived I'm trying to create another query to read the count of entries of each week in...

The change in values are occuring as soon as I add a second query to the design sheet, I don't have to even use any of its fields. Any ideas? Anyone?

I'm trying to create a query to create that counts the fields in other queries. I can count any field from any individual query with no problems, but as soon as I add another query to count, it gives produces a single abnormal total across all fields. When I run this code, it produces a single...

I take that back. I'm an idiot. Maybe I should have just used LEFT JOIN

I finally have this working right, but I just realized that it's not showing records for those entries that did not have records in each individual query. Is there some way to do something similar to a LEFT JOIN when using the make table query, so that it will show an empty record?

Access 2007 I am trying to create a report to replace a long running spreadsheet, I'm stuck with asthetics. The attached file is what I'm looking to achieve, but I cannot seem to find a setting or parameter to change the individual colors of the record entries. I'm assuming I will have to...

If I understand correctly, you could possibly do a sum by group query, then using those results to select records from individuals based on the size of the count (i.e. use [count] >1 in the criteria