Search results

Hello, Say for example one of the fields in a table is in the format of YYYYMMDD (i.e., 20070426 for today), and the number of years is in the format of YY (say 07) and I want to run a query to include only the data that when the years in YYYYMMDD is added with YY, the resulting year is around...

Hello, say for example I have a particular column in Access that I would like to force users to enter as percentage only, is there a way to format the cell as in Excel to create such effect? Thanks a lot! Regards, Anyi

ok, thanks a lot!

Thanks Ray for the quick reply, is there any documentation you could let me know on creating queries? The queries in Access seemed to be quite different from the SQL queries in peoplesoft or SAP... Thanks!

By the way, I would like to disable the editing of this field as well, may I know how can I do that? Thanks!

Hello, I am completely new to Access, so thanks to anyone who does not think my questions are dumb :) Ok, say for example I have a table that has my income information and my tax rate and I want to compute the income tax I need to pay by simply modifying total income with tax rate, how should I...