Search results for query: *

I have a table of data that has a date and qty field. For each month there will be 4 entries (one for each week). How can you select or display the last entry of each month?

I have a table that contains a field "Date" the format for this field is dd/mm/yyyy ie 01/01/2003. From this table I would like to get the all the dates that fall between 01/01/2003 and 31/01/2003. I have started with a form that has a combo box on it for the start date. I currently...

Would someone please be able to advise me as to how and when a switch function is used in Microsoft Access? Any information would be much appreciated. Thank you in advance.

Hi Bob, Thanks for the help with converting a positive to a negative number. Nicolle

Would any one please be able to advise me if it is at all possible to convert a positive number into a negative number in a field?? For example 1 to -1. Is there an access function that can be used to convert this?

Could someone please tell me if I have the syntax right when I want to compare the year from a table and the computer. eg (Year([HistoryHeader].[Date]))=Year(Date()) this gives me some 2003 but it also gives me 1999, 2000, 2001, 2003. I just want the records for 2003. Any ideas would be much...

I am hoping someone can help me get my head around this. I have entered in a Order Number ie 44/0008161 and can display this information as well as a Document Number ie 274854. The Document Number is my FK link between two tables. My question is is it possible to enter in a Order Number only...

I have developed a query that will give me all the information that I need to display on my report. Then when I design my report I select that query. Now I have it all laid out where I want it and all that is left is to add up all the record at are on the invoice. Now my problem is with the...