Search results

In the previous example ... The column of MON should be null and the last column of Numbers is under the WTD column.. sorry

Im sorry I should have mentioned that each different type of sale I have for the serial number needs its own total count for each day and then at the end of the week too. This is a really rough assignment and I could use the help... The reports supposed to look like this: SALES...

I am trying to create a report that groups by serial number and has dates across the top for a week (user input here). The report I want looks like a crosstab query, any dates that the serial number has had no sales is left blank and dates with info will populate. I have to have all 5 days on...

I have a query that shows the Product# on books, how we sold the book, and a count of how many sales. My manager wants 3 types of sales to be added together, is there a way to do this directly in a query? Adding up several rows of distinct information and placing the sum on one of the count...

MORE DETAILS I have a table that has the fields: psk (serial number) disp (type of sale) count 1718 1 7 1718 10 1 1719 5...

I was wondering if there was a way to pull up specific records from a grouping, place them where you want on the report and if there's no record to match your criteria then come back with 0. I have to create a report that needs to look exactly like what the company is using now, in the...

I have 1 table that has 1184 records with a number of fields including 1 field for the count purposely left blank (or Null). I have another table with 654 records that has a count in that field. I first want to populate the 1st table with the count information then populate the null's with...

I actually get the info from a space delineated text file. I import it and everything goes smoothly. But here's an example of what I get: ser# type count 1718 manualsale 7 1718 cdsale 2 1719 cdsale 8 1719...

I have been using Access for several years now building low end db's and only until recently have I come across this situation for a project I'm working on.... I have information in a table which is a ProdNum (which repeats for each type of sale) type of sale (each ProdNum has 1 or 2 never all...