Search results

But i don't want them to change the original data

Thank you for you help

I'm having issues how to design this form. I have form with (Date, ProductID, ProductName, ProductPrice and LastNumebrSold) This information is enter daily. For each day I like to see the previous days data all in one form and update only the [LastNumberSold] and also enter any new product that...

Hi, I have form that has four fields, (date, productId, Product name and price). Product name and product price I'm using Dlookup. Is there way when the product name and price is not in yet that I can enter mannualy in the same field. Thanks Hmho

I was able to put NZ and it worked thanks

I'm very new to this how do I do that? Thanks

Hi, I have continuous Form that I have two fields that using Dlookup. When I don't enter the look up filed or when I first open the form the fields for the look up are showing (error) but when I enter information is working fine. How do I move the error default. Thanks

I did still getting error. The field name is [AmountSold] and I put the formula in the footer as =sum([AmountSold]). Please help. thanks

Hi. I created report based on sub query but when I put formula in the footer for subtotal I'm getting error.

Table 1 Date Game ID Ending 4/1/2009 883 100 4/2/2009 883 200 4/3/2009 883 300 4/4/2009 883 400 Query1 Date Game ID Ending 4/1/2009 883 100 4/2/2009 883 200 4/3/2009 883 300 4/4/2009 883 400 I would like to add column in query one which will show me previous day’s ending Query1...

Hi I have report that gives me sales by day I want to add column that also gives me cumulative totals for each day. Can some one help me please. Thanks:confused:

I'm realy confuse can you give example. Thanks

I have table that has this data below. Basically I would like to find the diffrence between the End_No for today and previous day. For example between 04/07/09 and 04/06/09 the diffrence for End_No is 50-40=10. Please don't laugh I'm new to Access. Thanks:confused: Date G_No...